I’m starting to use more features in Airtable and I’ve run into something I can’t figure out. Can I have a table that lists records from multiple other tables if the record has a certain classification?
I’ve been reading about links and relationships but maybe I’m missing something.
Example: I have 3 tables in a base that each list songs by artists I like. Each table has a column with a single-select dropdown list if I want to buy a specific track. Can I make a 4th table that will pull all the records into one list from these three artist tables if the record has a “want to buy” label?
From reading other posts it sounds like I might have to have all the artists and songs in one table and then filter by “want to buy.” (Not my preferred solution but would consider it)