How do I write a routine that checks to make sure that a person isn't editing a record such that the newly edited record's primary key will match that of a record previously entered in the database? I though of opening a resultset whose SQL would have the resultset populated if there were any record with a matching primary key. But duh, the resultset will be always be populated unless you edit the primary key itself.