Forum Discussion

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

Icon for Qrew Legend rank

Qrew Legend

2 years ago

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
------------------------------

SolaceSonder1
Qrew Member
2 years ago
It doesn't seem to:

------------------------------
Solace Sonder
------------------------------
- MarkShnier__You
  Qrew Legend
  2 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)
  mark.shnier@gmail.com
  ------------------------------
  - 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
    ------------------------------