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?