Customer, Orders, & Order Details subform Example (1 Viewer)

mergle

Registered User.
Local time
Today, 00:58
Joined
Jan 31, 2003
Messages
54
I am trying to create a form/subform structure similar to the "Customer/Orders/Order Details" scenario, and I cannot find the exact format I am wanting to create.

Specifically, I would like:
1. The main form to list the Customer name;
2. The Customer Orders to be listed in a subform on the main form; and
3. The Order Details also to be listed in a separate subform on the main form.

I am sure I have seen this setup before, but cannot find an example similar.

Can anyone point me in the right direction?
 

missinglinq

AWF VIP
Local time
Today, 00:58
Joined
Jun 20, 2003
Messages
6,420
I suspect that you have an excellent example already on your hard drive! The Northwind.mdb database that ships with all versions of Access has a classic example of this using Customer Orders, Customer Orders Subform1 and Customer Orders Subform2 forms.
 

mergle

Registered User.
Local time
Today, 00:58
Joined
Jan 31, 2003
Messages
54
You know, I thought it did have that structure, but I am using Access 2007, and the Northwind.accdb does not have the same structure in that regard.

...so I downloaded the mdb version and found my solution.

Thanks for the redirect!
 

Users who are viewing this thread

Top Bottom