Reference to Table Rows from Many-to-Many relation

I have a Many-to-Many bridge table where I set the FK columns to Ref, which in turn automatically created a de-reference in each of my tables. This displays like this:
2X_d_d42c21ae300683800ab85246c6fd05fc59dad1bd.png

Ideally what I would like is rather than displaying the table with the two columns I would only like to display a table of the records on the โ€˜Annual Reportsโ€™ side. I attempted this by creating another virtual column in my Permits table with a formula of FILTER(โ€œAnnualPermitDataโ€,IN([id],[Annual Reports])). Unfortunately this did not return any records. My question is how I need to fix my formula and/or is there a more efficient way to accomplish this (something that would be less intensive from a query perspective)?

0 4 867
4 REPLIES 4
Top Labels in this Space