Master view of all 6 tables via 1 form

[Vince]

Hi,

I have a db that is driven by a TransID. There is a total
of 6 separate tables. Each table has a TransID connected
to the the Customer Table. In addition each table has
it's on Primary key id e.g. OrderID etc.

I am trying to create a form that will provide a birds eye
view of ALL the tables by opening one form, the form
wizard is giving me error "unable to create the form" Why
is this happening what can I do?

The tables are related?

Please advise.

Vince