List Boxes - Get Selected Value Based on Another Selection
I have two list boxes on my screen nameley Product Family and Species.
We show Quantity and Sales value but only show the quantity if the selected values have the same quantity units.
I have this working okay for Product family.
Species values can fall into different Product Families e.g. Sapele could have an entry in either the Sawn or Machined Product Family with these having units of m3 and lineal metres respectively.
The user does not have to filter on a Product Family, they could go directly to the Species filter.
This is where my question comes in...
Based on the users Species selection, I want to go to the Product Family list box and determine how many Product Familes match the selection.
For example...
The species Idigbo (m3) only belongs to the Sawn Product family whilst the Sapele belongs to both Sawn (m2) and Machined (lineal metres).
If the user selects Idigbo I can show the quantity as it only has the unit m3 whilst the Sapele selection won't display a quantity as I have mixed units.
