Hi Rebecca,

There are many ways to handle this situation. The most common way is to assign a surrogate key as the primary key. Often however, you need to create a match key which may consist of first and last name, and address perhaps. Whatever fields constitute your matchkey - you need to create an index on that expression. Then, before a new record is created - your code needs to perform a seek to see if that record exists.

HTH,

< JVP >

>I having a trouble with duplicate records and was just wondering
>if this is a common problem in vfp, and do most people write code
>to handle the duplicate records or do they write code to stop them?
>
>Thanks and have a good day!