AnsweredAssumed Answered

Conditional (2 Conditions) Value List

Question asked by IanSegers on Sep 8, 2011
Latest reply on Sep 8, 2011 by hbrendel


Conditional (2 Conditions) Value List


Hi there

I would like to create a conditional list. Based on 2 conditions. The first condition is the relation between my 2 tables. Products and LotsProducts 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