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

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)?

Yes.

1 Like

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?

Can you show me a screen shot?

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

Here is how the choice column is set up - perhaps this is the issue?

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.

4 Likes

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

2 Likes

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

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.