Conditional (2 Conditions) Value List
I would like to create a conditional list. Based on 2 conditions. The first condition is the relation between my 2 tables. Products and Lots. Products relates one-to-Many to Lots. My dropdown shows all Lots which are related to the selected Product.
So far so good. But my next CONDITION is based on a field of Lot. I have a field isActive (Allowed values: 'Yes','No'). I would like to show only the Lots in my value list which are ( related to the Product AND isActive has value 'Yes' )
So the current setting for my Value List is next :
- Use values from field
"Lots::Lot Number" > Include ony related values starting from "Products"
I am using of course FileMaker version 11.
Thanks for your time