>Hi,
>
>Is it a good practice to let users modify the 'Primary key' in a FoxPro table?

If you use surrogate keys is a bad bad idea.


>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.

In a Client Mant Form, I have to change DNI (Unique Identification for person in Spain). The form can be in Consult mode state, and the user has to push a button to change the DNI field, nad I show a new window to intro the new DNI...

...But user are user...

José Luis.