5 Replies Latest reply on Feb 19, 2017 1:12 PM by rkutcher

    Conditional Value Lists

    rkutcher

      I believe I have mastered the simple Hierarchal Value List.  At least I have numerous CVL's in my DB and they all work correctly.  I am now trying to create a CVL where two foriegn keys match.

       

      I have numerous Customers who each own numerous Machines.  The Machines can be of varying Types.  I would like to develop a CVL where I pick a Customer, then pick a machine Type and then pick a Machine from a CVL that has been whittled down to show only the Machines of a Type that are owned by the Customer.  At present my CVL's show all machines owned by the Customer rather than just those of a Type.

       

      I have Adventures I CVL's  and Adventures II CVL's.  Can someone suggest which type of CVL I should be working with to reach my end goal?  I've looked at them all and can't see an obvious (to me) choice.