>I have a VFP application that needs to run in several different sites, then merged together for combined reports. I
> need a better way to keep the primary keys from being duplicated. I am currently using a modified version of
> getid() to assign the keys now, but sometimes the users will have to restore their system and forget to re-set the
> key values creating a real mess. What would be the "pro" way to handle this?

If you're running in a CLIENT-SERVER setup,( i.e. SQL SERVER), try to put your procedure to TASK. So, everytime the SQL-SERVER starts, the server runs that procedure. see TASK in SQL-SERVER