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

HELP ~ How do I add a subform?

P: 1
Hi,

I need to add a subform to an existing form that I have.

The issue is that I have only 1 table that houses all of the data I require to be in there. The main table has 25 fields and approx. 1000 records currently. Of those records some of the information is the same, for example I have multiple lines for 1 customer, I would like to design a form that will show their information that would remain static to that customer, and then a subform that wold have each order listed below that in relation to the customer.

I hope that makes sense.....is this possible? If so how do I do this, I attempted splitting the table and setting up relationships but am having a very hard time with that.

Any input would be greatly appreciated!!!

Thanks!!!
Nov 30 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,

I need to add a subform to an existing form that I have.

The issue is that I have only 1 table that houses all of the data I require to be in there. The main table has 25 fields and approx. 1000 records currently. Of those records some of the information is the same, for example I have multiple lines for 1 customer, I would like to design a form that will show their information that would remain static to that customer, and then a subform that wold have each order listed below that in relation to the customer.

I hope that makes sense.....is this possible? If so how do I do this, I attempted splitting the table and setting up relationships but am having a very hard time with that.

Any input would be greatly appreciated!!!

Thanks!!!
You cannot do this unless you normalise your table. That means, at least, creating a separate customer and order table.

Check out the 'Links to Useful Sites' thread near the top of the Access forum for a link on how to structure tables in access.
Dec 1 '06 #2

Post your reply

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