I have created a self-join relationship using the same field in both TOC's to create the (=) relationship. This is to enable me to check for uniqueness of a field using
Count ( TOC::Field) > 0
The problem is that only the first line in the field is being taken into consideration. If a carriage return is entered into the field, any text following is ignored.
Does anybody know why this is the case?
Thanks in advance