Skip to Content
0
Former Member
Jun 10, 2009 at 08:12 AM

Restrict to enter more than one qualifier value for a different combinatio

23 Views

Hi folks,

i'm facing an issue which is like this:

I have a qualified table in which combination of non qualifiers is unique.For a record i can enter many combinations of non qualifiers.But for all the combinations of non qualifiers,I want to have only single/same qualifier value. There should not be multiple values for the qualifiers but they can be left blank.

e.g:

FIELD TYPES: NQ NQ Q Q Q

VALUES : A B 1 2 3

C B 1 2 3

R D - - -

Thanks in advance

Reg.

Bis