I have a many to many relationship. A bridge table connects the two other tables. I’d like to list the related rows in the detail view. Currently I only get the bridge table rows (which only contain ref. ids) in the detail view, which when I click on leads me to the detail view of the related row. What I need is the related rows directly in the detail view. Is this possible?
cheers.
It is possible. If you want further help, we’ll need to know the involved table names and Ref column names in the bridge table.
So let’s say I got TableA with two columns (Id, Name) and TableB with two columns (Id, Name) and then the bridge TableC with two columns (TableAId as ref, TableBId as ref).
When I open a detail view of recordA I want a list of referenced TableB names.
Create a virtual column in TableA with an App formula of:
SELECT(
TableC[TableBId],
([_THISROW].[Id] = [TableAId])
)
Note that this gets expensive pretty fast.
Thanks for the anwser!
@Florian_Junge Not sure if this will help you, or if I’m reading your requirement correctly, but I have similar many-to-many situations, and I often use the bridge table to provide the nested rows (in Deck view format) and configure inline reference actions in the nested view, so that although it is the bridge table, it looks and acts like the table I want.
So in your case, I would
I’m no expert, and would defer to @Steve, but this is how I do it. Many-to-many bridge tables certainly cause a lot of headaches!
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |