VBScript - determine whether a selection is valid...?

[#1]

Hi,

I would like to know if there is a way in VB of testing whether a selection is 'valid', e.g. say I have the following data:

A B

1 x

2 x

3 y

4 y

..and then I VB I do the equivalent of:

Field("B").select "x"

Obviously '3' and '4' are now no longer valid selections on field A where as '1' and '2' are. Is there a way of determining this at run time though for specific values of field A?

Thanks!

[biester]

It should be possible with GetExcludedValues (see API-Guide).

Rgds,
Joachim