Creating Report with lookup

[Guest]

I have created a database for my business. It has several tables including
Order history, Order Details, Suppliers, Customer Info.

All orders are tracked by an order number. This is the field used in the
relationships. It is a key unique field.

I am very new to this and have struggled to get this far but it seemd to be
wokring ok.

What I need a little guidance in is the best way to create a report that I
can print based on an order number lookup that will pull information from
several of these tables.

Should I create a query to do this? Or can this be done simply by creating a
report in the report-design mode?

Whichever the way if you can give me a little guidance and I will take it
from there.

Thanks

 

[Allen Browne]

Create a query that pulls the information from all the tables.

If some of the lookup fields are blank, the query will need to use outer
joins. Details in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html