Any time a record is added to the database is should have a primary key. This value should be created either when the record is initially created, or on the first save. Additionally, a primary key IMHO should never be re-used. That is unless there is a business reason for doing so. Actually when trying to track something, using the same unique id for two different things at different times can be hard to track over the long term.
>In addition to what Denis said you might want to look into the autoinc field type (if you have vfp7 or8). I have nothing but good things to say about autoinc.
>
>Einar
>>Hi Denis,
>>We have several users using the same program simultaniously and need to create new customers. It is not practical for me to create a customer record manually everytime they need it. I want to get it done thru the customer creation program itself.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc