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
------------------------------
Question
Create parent-child relationship when parent primary key is from composite key from sync
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.