Uniqueness

[scg198]

I have 2 fields and Fields A and Field B and i want the combination of both to be unique ie field A & field b to be unique value. How would you get it to check this not using a script. I cannot get it to work I think I have tried everything but do not want to use a script.

e.g

Field A = hello

Field b = Simon

I want to check that this has not been used before. I tried concatinating the 2 hellosimon using the autoenter but this then does not check if it is unique.

Thanks

[LiveOak]

Create a field:

Combo (calculation, text, indexed) = Field A & Field b

Create a self relationship (to the same file) with

Combo matching Combo. Call this relationship "SelfByCombo"

Create a field:

ErrorMessage (calculation, text) =

If (Count(SelfByCombo::Field A) > 1), "Error-Duplicate", "")

This self relationship looks for other records with the same values for Field A and Field b. If others exist, the ErrorMessage field displays text to tell you.

-bd

[scg198]

thanks all working corectly now Cheers