Forum Discussion

AnthonyGriffith's avatar
AnthonyGriffith
Qrew Trainee
9 years ago

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

5 Replies

Sort By
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      9 years ago
      So the issue will be if you can change the Key field of the Projects table to be the Job number. Do you have any other relationships in place now in that app where the projects is the Parent record in he relationship?
    • AnthonyGriffith's avatar
      AnthonyGriffith
      Qrew Trainee
      9 years ago
      Yep 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.