Relationship With A connected Table

  • 1
  • 1
  • Question
  • Updated 12 months ago
  • In Progress
I have a connected QB table in an app. This has record ID as the key field. It has a field known as location number. I am quite keen to relate this table to another table using location number as the linking field but cannot seem to find a way. Any guidance on this? I am happy to work off a replica mirror table if that is something can be created off the connected table or if there are any QB actions created but need help. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 12 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Is the Location # unique in that table?  ie are there any duplicates or could there be any duplicates?  If not, then you may change the Key field of the connected table to be the Location.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks.  Yes it is unique. This is an easy option and thank you for the insight. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
You should ensure that on the source table, that Location field is marked as unique.