Hi all, I am having issues configuring a subgrid for a M-M relationship self referencing an entity: Account <-> Account (Account_Financialinstitutions).
I am trying to capture which accounts are related to other accounts as their financial institution, and Im trying to add a subgrid to the main form view to show these relationships and to let the user add new ones if required.
The problem Im having is that when I add a new subgrid, I cant select this table, even configuring as "related records". It doesnt appear the reference table to be selected.
I went ahead, and selected "Accounts", then tried configuring the filters for the view, but again Im hitting a roadblock. When confguring the view filters, when I select from where and go to the "Many-to-Many" relationships, it does not appear. I have instead two "Accounts" (and assume that maybe one of them reference to the self-reference). I tried selecting this one, but again, I cant enter dynamic criteria on the filter, only static data, so I cant reference dynamically the record the user is viewing.
Does someone know how to achieve this? All I found are examples but with a new entity created, and not a self reference one (Account <-> Account).
Thank you!
10
Share
Report
All responses (
Answers (
