I’m working on a multi-site content audit for a University and want to create a separate table for each site and then pull all of the data in to a master table so I can run reports against all of it. I’m thinking I’ll need some separate columns for different sites, but will have enough universal that a single table pulling data from the others will make sense. Is there a way to say Column1 retrieve *Column1 data from X, Y, and Z tables?
Combining multiple tables into a master table (vs. breaking a master into smaller ones with queries)
No that option is not there but you can create buttons in Table X, Y and Z that create rows in the Master table. Take a look at this example -