Forum Discussion

SolaceSonder1's avatar
SolaceSonder1
Qrew Member
2 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...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Hmmmm, there must be an answer but I don't know what it is right now. I will have to try a test on my own or maybe someone else has an answer.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
SolaceSonder1's avatar
SolaceSonder1
Qrew Member
2 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
    Qrew Champion
    2 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
    ------------------------------