Relate records within the same table
I have one existing table listing client demographic data - Name, Age, Gender etc. I want to relate these records to each-other in the very much common event that some clients are related to each-othe...
Forum Discussion
Have no fear, you can easily relate a table to itself, multiple times even. Go to the settings of the table that you'd like to related and select the + New Relationship. After you've created a relationship between the same table, you may want to rename the name of the reference proxy field to something like 'Child Name' 'Grandchild Name' etc. Open the relationship you've just made to find and edit the proxy field name on the child table.
------------------------------
Ryan Parr
------------------------------
------------------------------
Ryan Parr
------------------------------
When updating a record to display the sibling, does it display in the other record?
------------------------------
Phelan (DHS) Sanders
------------------------------
------------------------------
Phelan (DHS) Sanders
------------------------------
- MarkShnier__You
Qrew Legend
I think you ned to clarify the question. It would make sense if it was a parent child relationships, just like in real life where a parent would have many children. The you would be siting on a parent record and see all the children.
But when you have pure sibling relationships, then it's more complicated and you may want to use a different method like creating a Family unit record to be a Parent to all sibs, so that each sib will see their other sibs on their record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
