I have created a new FileMaker solution and imported separate 'Client' and 'Job' tables. Due to the way they were created on the old solution the names in the client field in the 'Job' table match the clients in the 'Client' table, but they are not actually linked through the relationship. I can go into a 'Job' record and select the matching client from a drop-down field, which correctly assigns it, but I was wondering if anyone knows of a way I can automate this process. There's around 7500 job records and going through each manually assigning the relevant client will take me an age.
Thanks for your time,