Multi-valued Tuple Validation from Main record

59 Views

Hi All,

does somebody know how I can do a Validation from the Main Table against multivalues Tuple field?

The option for validation on the tuple table (dropdown list of all tuples) doesn't work for me as I am able to set the validation there only against the Tuple member fields, but not with reference to the Main Table record standard fields.

I try to do the validation against the Tuple[Record] field, but it doesn't work, even that it works on the Qualified field.

I need to achieve the following:

1. We have records in the main table containing one multivalued Tuple field. The tuple field has 1 Display field, which is lookup(text) field against lookup table. In this lookup table we have 2 display field: Source and Code (The source can be "W1" or "W2");

2. We want to check:

- if the field X of a record from the main table = "W1" - the choosen Tuple record should not contain W2;

- if the field X of a record from the main table = "W2" - the choosen Tuple record should not contain W1;

I tryed with this validation: IF(X=W1,HAS_ALL_VALUES(TUPLE.[RECORD],"W2")), but it always gives me FALSE.

I tryed also with FIND but the result is the same.

Did somebody found a way how to do it?

Thanks&Regards,

ILIN