Skip to Content
0
Former Member
Jun 22, 2011 at 11:27 AM

Validation Problem

22 Views

Hi,

Can i write a validation which checks and compares the Non qualifiers selected for a Record?

I have 2 qualified tables

table 1

process Type (Non qual) (lookup to table3 values)

status

table 2

Type (Non qual) (look upto table3 values)

Date

table 3 values

Name (Display Field)

-


non commercial

comercial

logistics

warehouse

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???

KR

John