Possible to link all data in ten tables to appear in one master table?

[rthakral]

Hi, good morning!



I was wondering if it was possible to have a master table where say 10 of my regulatory tables and their data once inputed from the forms will appear there? Is this possible? Because right now, each of my regulatory tables has a form where the data is inputed and appears within said table.

All these tables are separate, obviously. I want to consolidate all the information into one spot, is this a possiblity within access?

Thanks! Any help would be greatly appreciated!

[RuralGuy]

Do these tables have a relationship with each other? If so, you can put them in the same query.