Multiple Records to display on one form

[Brenda]

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

 

[John Vinson]

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

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!

 

[Hugh O'Neill]

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

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