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.