How prevent duplicate records?
Posted on 2014-02-17
I have a form which contains a field that is a "combination" field made up of other fields on the form. The form is bound to a table and the field is actually in a field in the table.
For example the form has "FirstName", "LastName","City" Or like "John Smith Greendale".
Since it is not the primary key field I want to find a way to prevent the user from entering the record since it already exists and alert the user that that record already exists and not let them enter it again.
How can I do this?