need to combine all 4 table to one form

[ckart]

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.

[NeoPa]

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.

[MMcCarthy]

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

[ADezii]

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...