How can I check if a value is in a valuelist?
I have a tree structure for products.
Top level, sub 1 level, sub 2 level.
there are 3 branches from the top level, multiple branches in the sub 1 level and then multiple results in the sub 2 level.
I have a table with the fields for Top, sub 1 and a repeating field for sub 2
ie there are many records with the same top values, the sub 1 value in each of these records is unique and then each of these holds the posible values for sub 2
I use this table in a conditional valuelist to only display those values that are valid for the top, sub 1 selection.
This all works Ok, in a new record I can select the top level and will be shown the valid options for Sub 1, after selection one of the valid sub 1 values I am then presented with the valid sub 2 values.
However most records already have the three level values entered and I now need to flag any that are invalid. ie the value stored in sub 2 is not valid for the values in top and Sub 1
an easy example would be top = Food, sub 1= apple, sub 2 = boot this needs to be flagged as wrong because the only valid values for top = Food, sub 1= apple, are Red or Green
In summary I need to check if the value in Sub2 is included in the conditional valuelist for sub2
I believe that your structure is incorrect. You should be using related records instead of fields for Sub1 and using related records (related to Sub1) instead of repeating fields for Sub2. It would help if you could upload your file so we can see exactly how you are structuring it. :^)