# Can a Record have a relationship with a record in the same table **URL:** \ **Category:** Ask for Help\ **Created:** [April 25, 2025, 10:56am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535 "2025-04-25T10:56:40Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![alan\_singer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alan_singer/32/77340_2.png) [@alan\_singer](https://community.glideapps.com/u/alan_singer)\ **Post date:** [April 25, 2025, 10:56am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/1 "2025-04-25T10:56:41Z")
I have a table of organisations I have a requirement to produce a list of subsidiaries for a company, bothe the parent and subsidiary company records are in the one table called organisations. Is it possible to relate one record (parent record) to a number of subsidiaries records (which also happen to be in the same table)? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 25, 2025, 10:59am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/2 "2025-04-25T10:59:23Z")
Yes. ---
**Author:** ![alan\_singer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alan_singer/32/77340_2.png) [@alan\_singer](https://community.glideapps.com/u/alan_singer)\ **Post date:** [April 25, 2025, 11:16am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/3 "2025-04-25T11:16:32Z")
Thanks @Darren_Murphy - to the rescue again!! Much appreciate your prompt response!! Its just that I can’t get it to work and I don’t know why I might be going from the wrong end - I am building the relationship where parent has many subsidiaries by adding the FK of the subsidiary into the parent record Maybe I need to establish the relationship by putting the parent’s key into the subsidiary FK? Your thoughts? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 25, 2025, 11:24am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/4 "2025-04-25T11:24:04Z")
Can you show me a screen shot? ---
**Author:** ![alan\_singer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alan_singer/32/77340_2.png) [@alan\_singer](https://community.glideapps.com/u/alan_singer)\ **Post date:** [April 25, 2025, 11:29am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/5 "2025-04-25T11:29:25Z")
![Screenshot 2025-04-25 at 9.21.04 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/30661aba653f81dac6f49c197c320c81a042debe.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 25, 2025, 11:31am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/6 "2025-04-25T11:31:35Z")
Is there any data in the Subsidary\_Org\_ID column? As long as you are storing the correct RowID values in that column, then that looks fine to me. ---
**Author:** ![alan\_singer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alan_singer/32/77340_2.png) [@alan\_singer](https://community.glideapps.com/u/alan_singer)\ **Post date:** [April 25, 2025, 11:34am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/7 "2025-04-25T11:34:41Z")
That is the problem @Darren_Murphy I am adding data in via the edit screen and the data is in there but the relationship column does not seen to be working ![Screenshot 2025-04-25 at 9.25.45 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d0e2738c9fd24f4b08881403c044bfe1b7824be.png) Here is how the choice column is set up - perhaps this is the issue? ![Screenshot 2025-04-25 at 9.27.26 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e4e596423b573ed01c3b744d6ea9f8547f19f17.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 25, 2025, 11:47am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/8 "2025-04-25T11:47:16Z")
Relations look for **Exact** matches. A comma delimited list of multiple row ID’s is not an exact match to a single row ID. However, if you Split that comma delimited list into an array of multiple single values, then it will work. ---
**Author:** ![alan\_singer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alan_singer/32/77340_2.png) [@alan\_singer](https://community.glideapps.com/u/alan_singer)\ **Post date:** [April 25, 2025, 11:52am UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/9 "2025-04-25T11:52:04Z")
Ahh of course!! Sorry - I had that once before - I will make a note of that one - the otehr way worked now I can see who is the parent of any company ---
**Author:** ![alan\_singer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alan_singer/32/77340_2.png) [@alan\_singer](https://community.glideapps.com/u/alan_singer)\ **Post date:** [April 25, 2025, 12:00pm UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/10 "2025-04-25T12:00:51Z")
All working now Mr. Darren!! You are a legend. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 2, 2025, 12:01pm UTC](https://community.glideapps.com/t/can-a-record-have-a-relationship-with-a-record-in-the-same-table/81535/11 "2025-05-02T12:01:37Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.