Link child to parent

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have 2 tables created in my app, one for clients and the second for their dependants. I've created a table to table relationship between the two tables with many dependants belonging to one customer. However, the dependant may belong to two customers, as often times our clients are spouses of each other. On the client table, we list the spouse under each client.

What I need to do is when I enter a dependant, it generally shows up under the primary client on the client's details. I'd like it to also show up under the spouse's details as the child belongs to both clients.

Photo of Lynn

Lynn

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
no problem.

Create a new relationship to Clients but call the new field Related Client Spouse.  Also lookup the Spouse name as a a lookup field and set the Proxy field for Related Spouse to be the Spouse name.
Photo of Craig

Craig

  • 0 Points
This is correct. If you need any additional assistance on this, please open a QuickBase Support case with the QuickBase Care Team.