I have X tables, each representing a different material type:
Material Type 1
Material Type 2
Material Type X
I need a Summary Table that consolidates the records from all of these tables with a "Type" field so that everything can be filtered.
What I want is for the summary table to automatically add new referenced records each time a record is added to any of the Material Type tables.
I can create one-to-one relationships between all of the Material Type tables and the Summary Table, but then I still have to go through and manually select each and every record in each and every Material Type table (I think). Maybe I am thinking/going about this wrong.
Thanks for any help!