Forum Discussion

SolaceSonder1's avatar
SolaceSonder1
Qrew Trainee
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 [email protected]. This is created during the automatic s...
SolaceSonder1's avatar
SolaceSonder1
Qrew Trainee
3 years ago
It doesn't seem to: 



------------------------------
Solace Sonder
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
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)
[email protected]
------------------------------
  • SolaceSonder1's avatar
    SolaceSonder1
    Qrew Trainee
    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)
      [email protected]
      ------------------------------