Understanding Header Tables in Access 2000 and above

J

Johnny Romper

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
 
D

Duane Hookom

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

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
 
Top