Would like to introduce 6 tables that are related and put them on one form. Have actioned this using form wizard they show in design view but not in the main form????? Help please!!!!

One word ... SubForms. Use 6 unique Subforms on one main form.

Hi Jo

You will be able to get 5 tables on to a form without having to put into 6 subforms.

Then you can install the last table as a subform.

One nice way of presenting data on a form is by using the tab control and build up the pages then by dragging the information down from the field list stick the information onto the individual pages.

I hope this will help!!!

HL