>Please, tell me, what you mean under "renumbering records" ? This question tears me apart and I even can't sleep :)
>Are you really going to change RECNO() ? Or you are speaking about a simple REPLACE...ALL ?
Well, I needed to change the sequence number (it's an integer field in my table). So, for each FK I needed a sequence from 1 to the number of records for this FK. I also needed to figure out how would I change the number to not mess up the original numbering (at the end, I didn't take this into consideration, so I may have some surprises tomorrow).
Anyway, while you were sleeping I already implemented quite simple algorithm and ran it in production.
So, you may go to sleep or are you starting your work day already? If yes, all the best to you and good luck!
If it's not broken, fix it until it is.
My Blog