Table to table relationships using Sync'd data

Hi. I'm importing data directly from Qbooks into a new table in Qbase. This imported data contains invoices / debtor info. I have a field call [job number] that matches a field in our existing table "...