>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.
Quidquid latine dictum sit, altum sonatur