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!