One Form to many tables help?

[kcddoorman]

I'm making a shop order entry system. Basically I take a work order that a sales person writes and rewrite into a door builders language. I'm having trouble with the form's record source. I have multiple tables that contain related information about such things as door type, customer name, and ready date. There is a lot of information to be stored into these tables. When I go to connect the form to the tables I get the query builder and I give it all the tables information. The problem is that there is way to many fields. The limit is 255 but the combined fields of all the tables is massive. What am I doing incorrect here. Is there another "model" I should be following?

[MMcCarthy]

I'm making a shop order entry system. Basically I take a work order that a sales person writes and rewrite into a door builders language. I'm having trouble with the form's record source. I have multiple tables that contain related information about such things as door type, customer name, and ready date. There is a lot of information to be stored into these tables. When I go to connect the form to the tables I get the query builder and I give it all the tables information. The problem is that there is way to many fields. The limit is 255 but the combined fields of all the tables is massive. What am I doing incorrect here. Is there another "model" I should be following?

Why not create a series of subforms with Customer table as the main form. Each subform could be placed on a separate tab of a multipage form.

[kcddoorman]

Why not create a series of subforms with Customer table as the main form. Each subform could be placed on a separate tab of a multipage form.

I tried using subforms but the way it gets printed out looks bad.

[MMcCarthy]

I tried using subforms but the way it gets printed out looks bad.

Did you use a multi page form?