I have an API call that brings in the updated information on employees based on location.  I have an employee table and a jobs table.  The jobs table is related to the employee table as an employee is based at a job.  I run the call and if the job location has changed it is brought in as a text field.  How to I relate that field with the related table on update? Thanks any suggestions are appreciated.