General information
Category:
Coding, syntax & commands
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!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only