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