3 Replies Latest reply on Sep 8, 2011 4:46 AM by hbrendel

    Conditional (2 Conditions) Value List



      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