Table to table relationships using Sync'd data

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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
Photo of Anthony

Anthony

  • 40 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
Which Table would be the parent table, Projects or QuickBooks Synced Invoices?
Photo of Anthony

Anthony

  • 40 Points
Projects will be parent. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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?
Photo of Anthony

Anthony

  • 40 Points
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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
I have used that technique in the past and it has worked for me.  In my case I believe I made a Sync table of a Sync table but with a different Key field.