Can i write a validation which checks and compares the Non qualifiers selected for a Record?
I have 2 qualified tables
process Type (Non qual) (lookup to table3 values)
Type (Non qual) (look upto table3 values)
table 3 values
Name (Display Field)
Now when i have a record and they selected 2 values as Non qualifiers in table 1
Now i need to make sure that the user selects the same types (that are selected for Table 1) in table 2 - type field.
if the user select different types in table 2 which are not selected in table 1 then there should be an error.
I am not sure how to write this validation on the qualified tables..
Can anyone help???