self-join does not work
I would like to create a self-join.
I have a table with records of paintings. Some paintings are related to other paintings. One painting can be related to more than one painting. The other painting can also be related to other paintings. A many-to-many relation.
I link the records manually with a valuelist.
I tried to solve this issue with a join table since it is a many-to-many relation. I have been able to link painting A to painting B and show this in the portal of record A. But it does not show painting A in the portal of painting B. This is correct because I have two TO's of the same table and the portal shows only records of one TO.
How to mirror the records to one portal?