In my base I’ve got about 12 different tables. In each of those tables I have a “Brand” column that is “multiple select” and every table has the same 15 different “Brands” to select from. So every record in every table is tagged with one or multiple brands.
I want to create a table in that same base that aggregates all records from all tables and sorts them by “Brand”. I assume this could be done through some sort of linking method, but so far I’ve been unsuccessful. Any suggestions out there?
Thanks in advance!