PKs use is to uniquely identify a record and to use that to link to other data. If you use surrogate keys, as discussed in the article on my web site, you will never need to change them, as they are unrelated to the data and the user has no need to see them. IMO, this is the best way of doing PKs. If the user wants to identify a record by some other means, you can provide that as a Candidate Key.

>Hi,
>
>Is it a good practice to let users modify the 'Primary key' in a FoxPro table?
>
>And if it is necessary that the primary keys be changed, would it be better to have a separate form/screen to handle this? I am afraid that if I let them change it on a form/screen where they can change evrery other value in the table, I might end up duplicating the records.
>
>Any suggestions will be greatly appreciated.
>
>Thank you.
>
>Ria