How to have selection only show linked items?


I am trying to create a selection that only shows relevant items. For example, say we have 3 stores (Target, Walmart, and Costco) that sell different brands of items (Brand A, Brand B, and Brand C). Target only sells Brand A and B. If I enter “Target” as the store in my table, is there a way for another column to let me choose one of the two brands Target offers (i.e.- choose from Brand A or Brand B only)?

I’ve seen the Lookup field type, but this displays Brand A and Brand B, whereas I want the user to be able to choose one of the Lookup options. Is this possible?

This is just a test scenario I am trying to get working to see if Airtable is capable of doing what we need before getting more complex.

Thanks in advance for any help you can provide!


That is not possible now, check this: