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


  • 0 Points

Posted 3 years ago

  • 0
  • 1
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


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