How to detect duplicate record during data enry ?

[COOLROGER]

Hello Freinds,

Like to know if it's possible or is there any script exist to detect a duplicate record during data entry and prompt for proceed or cancel. If some one can help me .

Thanks

[CobaltSky]

Hi,

The answer yes, but how to go about it depends somewhat on how you define 'duplicate'. Strictly speaking a duplicate record is one on which all fields hold the same values as an existing record - but the term is frequently used more loosely.

If you are referring to a record in which the value in a particular field already exists in the database, then the 'Unique' validation option may suffice. However if your definition of duplicate depends on the values in a combination of two or more fields being unique, then you will require a slightly more complex set-up.

If you could perhaps add a little more detail about what you are trying to do, you might get an answer which is more relevant to your circumstances.