marcoman44
IS-IT--Management
I am in a situation were external factors are forcing me to change the Primary Key of my main table. The ID (Member_ID) is now only used for a segment of the business. The Member_ID field is the Foreign Key in multiple tables. The goal is to make Member_ID an int(autonumber). I already created a new field and updated Member_ID1 (There is also a Member_ID2 which is forcing me into this situation.) with the old Member_ID. I am just looking for some advise when updating the ID. I don't think I can do this through an update query.
Thanks
Thanks