Selecting certain records

[Tremor]

Hi all

Not sure if this should be in here or in the queries section.

What I want to do is produce a report from my SalesOrders table which will be formatted as an invoice which can then be printed.

But I'd like to be able to select the CustomerOrderNo record I require from the SalesOrders table, and then have the report or query pull in the relevant records from other fields I specify - such as CustomerName, AmountOrdered, InvoiceTotal etc...

Is this possible?

Thanks in advance, Paul.

 

[HiTechCoach]

It should be possible. What you have described is how a relational database is intented to work.


You might want to check this out:
Customer Order Entry Template