I have recently written something very similar to this. It may be a little rough but I will send it to you tomorrow (Monday) morning if you are still interested.

Dan

>Fellow Mere Mortals
>
>Does anyone out there already have a utility that will cycle thru Id.dbf and for each entry, open the table, order it by it's Primary Key, go to the bottom, get that value, increment it by 1 and then update id.dbf?
>
>I hate reventing the wheel. Does anyone know if the Stonefield SDT does this?
>
>Thanks In Advance,