Help with multi conditional value list.
I have a costing system with forms based on customer and jobs which opens a portal based on jobdetails. I have three table linked which are product group, product type and products, which i want to use to select products and services against each job. The relation ships are shown in the file i have uploaded (conditional value list).
I have used the links within the forum to get me to this point but i am now stuck. I have no problem with the group and type drop down list which work perfectly every time but when i select the product drop list it always has the data associated with the first record in the product type list.
Any ideas ?