Multiple table data in a form

[jk12]

Hi all i'm in desperate need of assistance. I am trying to construct a form but require data to be drawn from multiple tables (7 to be exact). I considered creating a new table but then i would be repeating data and i considered using a query but unusually the required number of fields would exceed the limit in the query.

Any ideas then on how the data could be drawn into a single form from the 7 tables?

 

[Bat17]

if the tables are the same format you could use a "union query"

Peter

 

[jk12]

The the tables contain different types of data mainly yes/no, numeric, text and memo.

 

[Bat17]

sub forms on a tab control?

Peter