Multiple Records to display on one form

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

I'm having difficulty getting multiple related records to
display on one form... for example: Master Account and
all sub accounts
 
I'm having difficulty getting multiple related records to
display on one form... for example: Master Account and
all sub accounts
Click to expand...

Well, what have you tried? How are your tables structures?

Remember - YOU can see your database, and know how it's built. We
cannot.

I'd guess you need a Form displaying the master account, and a
continuous Subform displaying the subaccounts - but without knowing
anything about your tables, I don't know if that will help!
 
Brenda said:
I'm having difficulty getting multiple related records to
display on one form... for example: Master Account and
all sub accounts
Click to expand...


You will need to have two tables for the main and child records, linked
with referential integrity. Then you will need to construct a
mainform/subfrom with the master/child link set correctly for this to
work. The subform wizard does a passable job of this for you and then
you can tweak the code yourself if you need to.

hth

Hugh
 
Back
Top