Sorry for taking so long to get back to you. I just now discovered the replies button on the top of the web page.

I avoid autoincrements mainly because of the gymnastics that I have to do find out the PK when a record is added in VFP. I think it is better to get the PK from a control table and then insert a record into a view or cursor and then insert the row into the table when the user says the data is correct. I was burned badly one time when I was using @@identity to get the PK and what I was getting was a tables PK that was being inserted by the trigger.

I was also told that autoincrements should be used in a replicating system. I must admit that I have not used a version of SQL Server greater than 6.5. I have mainly use Sybase SQL Anywhere for the last 4 years.