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

need to combine all 4 table to one form

P: 1
i have 4 tables with one to many relationships. how can i make my form in access so it will display all the info at once. i know that i can do that up to 3 tables only.

Any ideas?

I try to do other forms and use buttons to filter data but still is not working.
Nov 23 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,186
Create the query of the data you want using Access's Design View.
When it does what you want, save it and have this as the source for your form.
Nov 23 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
i have 4 tables with one to many relationships. how can i make my form in access so it will display all the info at once. i know that i can do that up to 3 tables only.

Any ideas?

I try to do other forms and use buttons to filter data but still is not working.
There is no rule that you can only use three tables. The rules are to do with the relationships between the tables not the amount of tables. There is a limit to the number of fields you can output from a query. I think it's 255 and you should never normally reach anywhere near that.

If you're not sure how to get the output you want then post the details of the structures of your tables (e.g. primary and foreign keys etc.) and we will try to help.

Mary
Nov 23 '06 #3

ADezii
Expert 5K+
P: 8,597
i have 4 tables with one to many relationships. how can i make my form in access so it will display all the info at once. i know that i can do that up to 3 tables only.

Any ideas?

I try to do other forms and use buttons to filter data but still is not working.
Combine all 4 Tables into a single Query with the established Relationships existing for all the Tables. If these Relationships were pre-defined in the Relationships Window, this process will become automatic. Drop any Fields from all 4 Tables into the QBE Grid. Create a Form and set the Record Source property of this Form to the previously created Query. All the Fields that you previously dropped down into the Query Grid will now be visible in the View - Field List Option. Drag any of the Fields onto the Form. You can now reference the values of these Fields in Form View.

Hope this helps...
Nov 23 '06 #4

Post your reply

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