Faced with the prospect of writing my own or getting one already written I'd thought not reinventing the wheel was logical. What I'm looking for is a utility that:
a.) queries for the primarykey, looks up the primary key in a table or uses some other method of getting the primary key.
b.) Then synchronizes the id.value with the last value of the primay key + 1 using the incrementprocedure and the newid function in the database stored procedures.

I'm doing mulitple converts from older systems and have to keep id.dbf in sync.

Free is best, of course, but i'm willing to listen too. Thanks.