Select row from another table that meet two conditions

AppSheet AppSheet Q&A
1

Hello,
I have a “Storage” table with the following fields: RowID, LocatorID, ProductID, Color, Qty
In “Delivery” table, I want user to select LocatorID and ProductID, then they can only select available color of the selected ProductID in the selected LocatorID.
What can I do that in Appsheet.
Thanks.

2

Hi @pmhungdao,

Welcome to the community !

You may want to have a look here:

3 Likes