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