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