RE: [MS_AccessPros] Union Query -- redesign

Bill,
I think you have the form/subform concept understood. In the Northwind, I was referring to the Orders form with the Order Details subform. I haven't looked at a recent version of Northwind as my Northwind "sandbox" dates back to about 2000.

Duane

To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Thu, 1 Dec 2011 12:14:16 -0600
Subject: RE: [MS_AccessPros] Union Query -- redesign

Duane,
I now understand the scaleable concept and my tables will work.
I tried to look at the Northwind database to see forms, sub forms and sub
sub form but I could not figure out which form to look at. Do you know what
for would be a good example.

I plan on having the Sub form based on a CustomerID in the Main Form and I
am going to try to have a SubSub Form based on AgentID on the Sub form. In
my mind that is the only way I can think of to get all the field on this one
form.

One customer can have 7 types of insurance, each line of insurance can have
a variety of agents associated with it.
So I want the form to show the Customer, each line of insurance and each
agent associated with each line of insurance.

Thanks,

Bill Singer
Access Rookie
MN

Subject: RE: [MS_AccessPros] Union Query -- redesign

Bill,
You need to use forms with subforms for maintaining records is various
related tables. I'm not sure why you are mentioning "5" and "6". If your
tables are set up correctly, you don't typically have to worry about these
numbers since they should be scaleable from 0 to 100s without redesigning
anything.

Have you looked at the sample Northwind database to see how it manages
orders with related order details and products?

Duane Hookom
MS Access MVP

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/