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