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 hap…

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.

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 pare…

[Screenshot 2025-04-25 at 9.21.04 pm]

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.

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] Here is how the choice column is set up - perhaps this is the issue? [Screenshot 2025-04-25 at 9.27.2…

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

All working now Mr. Darren!! You are a legend.

Can a Record have a relationship with a record in the same table

Ask for Help

alan_singer April 25, 2025, 11:29am 5

Topic		Replies	Views
Pass the current record ID to a form Ask for Help	10	695	January 17, 2024
Missing relations Ask for Help	6	375	April 23, 2022
Row ID Used in Relation not working Ask for Help	16	862	February 26, 2022
Collegamento tra tabelle Ask for Help	3	310	August 16, 2021
Setup parent child relation based on rowIds Ask for Help	3	592	January 17, 2024

Can a Record have a relationship with a record in the same table

Related topics