Using the same form multiple times with different tablesa

[urobee]

Hy,
I have a Main form with tabcontrol, + a "data form" and some tables.
Is there any option to use the same "data form" on the tabs but with different tables?

Thanks!

 

[theDBguy]

Hi. If you have multiple tables with the same structure, you might not have a normalized design. What are in those tables?

 

[urobee]

It's made for a huge data collecting project.
We collect survey responses from four different areas. (the questions are the same for all four areas)
So my idea was to use the same form because the structure is the same all of the forms and the tables too.

 

[theDBguy]

It's made for a huge data collecting project.
We collect survey responses from four different areas. (the questions are the same for all four areas)
So my idea was to use the same form because the structure is the same all of the forms and the tables too.

Hi. If everything is the same for all four areas, then you only really need one table and one form. You can still use a tab for each area and simply display the same form in each but with the data filtered to show only the appropriate area. That's where the power of queries come in.

 

[Mark_]

It's made for a huge data collecting project.
We collect survey responses from four different areas. (the questions are the same for all four areas)
So my idea was to use the same form because the structure is the same all of the forms and the tables too.

If the table structure is the same for each area, then AREA becomes a field in your one table.

 

[MajP]

If the table structure is the same for each area, then AREA becomes a field in your one table

FYI,
As Mark says this can be easily combined into one table. You can use a union query to do this and then make a new table from that. Regardless of how huge the project is, it would be easy to combine the tables into a single table.

 

[urobee]

@MajP
@Mark_
@theDBguy

Thank You Guys!

 

[theDBguy]

@MajP
@Mark_
@theDBguy

Thank You Guys!

Hi. You're welcome. We're all happy to assist. Good luck with your project.