Understanding Header Tables in Access 2000 and above

[Guest]

Friends:

I am looking to understand the design of Header tables in Access.

For example, I may have a header table that contains customer order header
information such as Order date, Order total, etc.

The order detail table which by the way is dependent on the Order Header
table contains the acutal customer items, quantity ordered, unit price, etc.

How are header tables constructed? Can someone point me to a resource where
I can learn more about this feature of Access.

Thanks in advance

 

[Duane Hookom]

Tables are tables. You create them all the same. You can use code, SQL, or
user interface.

 

[John Nurick]

Take a careful look at the Northwind sample database that is installed
with every copy of Access.

On Tue, 15 Feb 2005 18:09:46 -0800, "Johnny Romper" <Johnny