changing the parent ID field -- Best practice ?
Before I learned to use auto-gen serial numbers as parent ID's for related tables, I built a database that related to normal data-entry fields. Years later I'm returning to this database, and want to update it (create new serialized ID fields and link the tables by these). I've got probably 15 tables with several thousand records each. Obviously I don't want to lose all the links....
If you have a method that works, please let me know.