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
Tidak ada komentar:
Posting Komentar