ContributionsMost RecentMost LikesSolutionsRe: Table to table relationships using Sync'd dataYep the projects table is central to our system and has 20+ relationships. What i'm playing with at the moment is using Quickbase Actions to create a clone projects table that has job number as key field and then creating a relationship between this and the table holding the QBooks data. Its giving me summary data which is a start and my next thought is i may be able to use lookups to pull the original project Id down to sync table (via clone) then use it to link back to original projects table. Not sure if that will work but worth a shot.Re: Table to table relationships using Sync'd dataProjects will be parent.Table to table relationships using Sync'd dataHi. 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