Using the same form multiple times with different tablesa (1 Viewer)
- Thread starter urobee
- Start date
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.
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.
- Local time
- Yesterday, 18:12
- Joined
- Oct 29, 2018
- Messages
- 21,453
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.
If the table structure is the same for each area, then AREA becomes a field in your one table.
MajP
You've got your good things, and you've got mine.
- Local time
- Yesterday, 21:12
- Joined
- May 21, 2018
- Messages
- 8,525
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.
- Local time
- Yesterday, 18:12
- Joined
- Oct 29, 2018
- Messages
- 21,453
Hi. You're welcome. We're all happy to assist. Good luck with your project.
