Too much info for one page

[lawdy]

I have 4 tables, each linked one to another. It is too much info for one page. I thought a tabbed form would be the answer. However, it seems that I have to put a subform control on the tab in order to put the form on it. This causes the form to display only one record (it will not let me advance to another record). (The form works proper as a stand alone form.) I was planning a using the 'side by side" way of linking them. I hope this is clear. Any help is appreacted.

[June7]

Why are you joining 4 tables? Data entry/edit can be done on only 1 table at a time.

[lawdy]

They are all 'one to many' relationships. One table would be hugh. I need to put information in each table for each proposal I do.

[June7]

Doesn't alter the fact. Data entry/edit to one table only.

Use form/subform arrangement. http://office.microsoft.com/en-us/ac...010098674.aspx

[lawdy]

Ok, but Form 'a' still has to be related to form 'b' and so on. I wanted to put form 'a' on one tab of a form. Then forms 'b' and 'c' on the second tab.

[June7]

Same advice. Use form/subform arrangement for 1-to-many related tables.

If you want to synchronize two related subforms review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp