Interesting Conditional Value List Question
So, I have a table of <Machines>, that have fields Machines::machineName and Machines::MachineType. I also have a table of <CommonIssues> that have related issues for those various machines, related by CommonIssues::MachineType<-->Machines::MachineType.
I would like the user interface to select a machine type, be given a list of machines that meet that criteria, and then a list of the issues that are associated with that type of machine.
So far, I can get a VL of types of machines, and then a CVL off of the type, but I can't get the Names of machines to become a CVL based on the initial selection of Type.
Have i missed setting up an extra relationship? Or should I do something with the table structure?
A little confused...