Dear All,

I have a field text and a field number, when people enter record , I don't want people enter the same text and number. If they do , show a message right away.

let's say ..first record Field A = A Field Num = 9

second record ...Field A = A and Field Num = 9.

How can the message show right away so that they have to change different text or number? ...IS there a way to check people?

Can you guys help me out of this?

Thanks a bunch.

Hi, Ahn:

This isn't a script, but when in "Define Fields" for either text or number fields, you can go to the "Options/Validation" tab and select the "Unique" checkbox. This should prevent people from entering duplicate values. Hope this helps.

Regards,

Philip Sommers

What if Tranh wants to either have A or 9 entered two times, but not the combination of both.

Here is the method I use to control duplicates in my contact db.

I use a script with a calculation for FirstName&LastName and a selfrelationship based on ContactsFile:cFirstName&LastName::FileA:FirstName&LastName with script :

If valid (relationship)

Show message "This contact seems to exist. Would you like to check if it isn't a duplicate".

If Status(Message) = 1

Go to related records

End if

continue script...

But I would really appreciate an easier method if it exists.

Thanks All,

I found the solution already ...use the self-join and create a calculation field to count the self-join.. count(selfjoin:field) > 1, wrong, false

Thanks All