AnsweredAssumed Answered

changing the parent ID field -- Best practice ?

Question asked by firth5 on Jul 3, 2012
Latest reply on Jul 6, 2012 by firth5

Title

changing the parent ID field -- Best practice ?

Post

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.

Thanks,

eric

Outcomes