Skip to Content
0
Former Member
Aug 20, 2008 at 04:29 PM

Validation in main table based on values in qualified table

12 Views

Consider the scenario:

Qual table:

Name | Status

S1 | P

S2 | F

S3 | P

Main table having qual links:

Record1 ¬

S1 | P

S2 | F

S3 | P

I need to fire a validation (check) to see which records have value 'F' in status... and then syndicate them..

Is it achievable? I tried using Qual.Status in main table but somehow not achieving what I need...