By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

One Form to many tables help?

P: 76
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
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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

P: 76
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 10K+
P: 14,534
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.