467,219 Members | 1,051 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,219 developers. It's quick & easy.

One Form to many tables help?

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?
Nov 30 '06 #1
  • viewed: 1238
Share:
3 Replies
MMcCarthy
Expert Mod 8TB
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.
Nov 30 '06 #2
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.
Nov 30 '06 #3
MMcCarthy
Expert Mod 8TB
I tried using subforms but the way it gets printed out looks bad.
Did you use a multi page form?
Nov 30 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Sean | last post: by
1 post views Thread by meganrobertson22@hotmail.com | last post: by
3 posts views Thread by Susan Bricker | last post: by
1 post views Thread by Kevin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.