Forum Discussion

SolaceSonder1's avatar
SolaceSonder1
Qrew Member
3 years ago

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

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 s...
SolaceSonder1's avatar
SolaceSonder1
Qrew Member
3 years ago
I'm gonna open a support case just to see if this restriction is intentional and if there is some documentation on it. I'm gonna try to get around it by doing a full copy of the table through an automation and then assigning keys that way.

------------------------------
Solace Sonder
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Do you really need a relationship?

You can have a report link field without having a relationship.

If you need summary fields that would normally happen on a relationship you can use a formula query for that.

So you should probably be able to get the features of a relationship without having a relationship.

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