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 "Projects". I'm looking to create a relationship between them so i can start to combine the data in existing status formulas etc. 
Is this possible? or is it better to try and merge the data. 
Thanks