Posted on 2004-09-20
Hi...Have two fields in a form A1 & A2.
both the fields can store multiple values in it. each value is 13 bytes long.
Now I've to put a validation so that no duplicates can be entered.
In A1's input translation I've @Unique(A1)
In A2's input translation I've @Unique(A2)
But i also want to restrict this. If a value in in A1 and the same value is in A2. it should give an error message.
I did put the following in A2's input validation.
@If(a2 = a1;@Failure("cannot enter duplicates");@Success)...
But this works only for some values.(Not sure why... may be becuase A1 and A2 are multi-value fields)