Skip to main content
Question

Relate records within the same table

  • February 6, 2020
  • 0 replies
  • 41 views
Forum|alt.badge.img+7
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-other - as in siblings.

------------------------------
Phelan (DHS) Sanders
------------------------------
This topic has been closed for replies.

  • RyanParr
  • Registered
  • February 6, 2020
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
------------------------------
Terms & ConditionsAccessibility statement