Changing table relationships.

Discussion created by tods on Jan 20, 2017
Latest reply on Jan 20, 2017 by tods

In the solution i am working on, I have a service record that is associated to an equipment table by phone number (this is bad).  The problem is that sometimes the phone number changes, so before things get too out of whack I need a way to go through all of the records in the equipment table, find the corresponding information in the service record table by phone number, get the primary key from the service record and put that into the foreign key field in the equipment table.


What is the proper way to do this?  I can't seem to wrap my head around it.


Thank you,