Skip to main content
Question

Create parent-child relationship when parent primary key is from composite key from sync

  • October 13, 2022
  • 0 replies
  • 252 views

I have two tables, Patient sync (parent) and Labs sync table (child). 

The Primary Key of Patient sync table is a composite key Jane_Smith_janesmith@fake.com. This is created during the automatic syncing. 

The Patient Labs sync data has the first name, last name and email of the patient in it in 3 separate fields. I want to connect these two records automatically when they sync if those 3 fields match.

When I try to create a parent child relationship, QB does not give me the option to set a reference field. It goes straight to a lookup field. I I configure the relationship, this is what I get, but the Related Healthie Patient field doesn't populate with anything because it is not the formula field from the lab child table. 


Is there some restriction on composite fields that I don't know about? Any suggestions about how to get around this and link these tables automatically during the syncs?

------------------------------
Solace Sonder
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 13, 2022
Does it let you change the field type of 
[Related Healthie Patient] to be type formula text?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------