How to have selection only show linked items?


#1

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!


#2

That is not possible now, check this: https://community.airtable.com/search?q=filter%20linked%20records