I’m glad that my comments have helped in some way but it’s clear that you still need to learn a lot about how to set up a base in Airtable. Besides learning about relationships, you should look at Tables, records and fields, and the other help topics.
As for linked fields vs. Single Select, the decision involves three considerations:
- Whether you need additional information about the field
- How many choices there are the field
- How often you’ll be adding options or editing them.
For example, you probably should have “Brands” as a separate table:
- You’ll want info about each brand (e.g. logo, company info and details) so you can create fields for that info.
- It would be difficult to use and maintain a Single Select field with 150 items, and colors probably won’t be helpful.
- As you discover new brands, you can easily add records to the Brands table, instead of having to modify the field in the Master table.
With “Status”, it probably makes more sense to have a Single Select field.
- It’s unlikely that you have to specify additional info about each status. (I can imagine that you might want that additional info, e.g. instructions on what to do for each Status, in which case you can create another table (“Status”) and link it to Master by using a linked field.)
- You have only 10 different statuses. The colors can be helpful.
- It’s unlikely that you’ll be adding statuses so you don’t have to worry about reconfiguring the field.
The reporting from within the Master table will be the same whether you use Single Select or a linked field.
You can change a linked field to Single Select and your data will remain intact.
Take a look at this: Guide to filter and record visibility.
One more thing: If you are considering making major changes to your base, first make a copy in case you make some serious mistakes that can’t be easily reversed. See Duplicating an existing base.
Hope that helps.