Is it Possible to define the result of a calculation field to be unique?

[Baylah]

Hello everyone,

Is it possible to define the results of a calculation field to be unique without transferring the results of the calculation to a different field?

For Example

FullName=

FirstName & " " & LastName

Result not allowed if not unique.

I don't see how to add a valdiation without taking the result and trasnferring it to another field that allows for validation.

Am I missing something basic that I should know about, perhaps in the functions?

This might seem like an odd request as I think about it, but it is import to the DB I am working on.

Steve

PS It is not about names...but that was easy to demonstrate!

[Raybaudi]

Hi

why not use a field with auto-enter option of a calculation and validate only if unique, instead of a calculation field ?

[Baylah]

That is a Da** good suggestion! I should have thought of that! Thank you...Problem solved!

Man I hate it when I miss the obvious.

Thanks,

Steve