Checking for duplicate fields

[SteveGriff]

Hi people. I need some advice on solving this problem.

I have two fields in my contact database called "Company Name" and "Client Name". What I need is a sure fire way of checking that when a user enters a piece of data into a record, that the user is not entering contact details that are already in the database. Basically, I need something to check that if the user has entered a company name and a client name combo that has already been entered into the database before, and if it has, spring up some kind of alert.

Hope this makes sense, and someone can come back with an answer that will solve all my problemos!

Thanxs people,

Steve Griff

[falkaholic]

One way would be to make a calc field that combines the two names:

ComboLinkCalc = Company Name & " " & Client Name

then make a self relation to that field.

then in the field validation, have something like this:

if( count(SelfRelation::ComboLinkComboLink), 1, 0 )

If there is a match for the current combo, there will be a count of > 0 for that relation, if < 1 then the validation wouldn't go through.

HTH