Diane,

> I am working with VFP 6.0 and using automatic key field increment from SQL server for all the views I have. During the time of working with them, the key fields have been increasing and they are big numbers now. Is there any way that I can make them start over at 1 or less than the numbers I have righ now?

Why do you want smaller numbers? Are you using the keys for some purpose other than as keys, like perhaps for invoice numbers or customer numbers? If not, there should be no reason to reset the keys. If so, you probably should consider letting relational keys be just that, with no other purpose.

Are your data tables so large that you are running out of numbers?