Solved: Action button to Related Table View - Page 2

David_Hundt · 09-18-2020 01:00 PM

I’m not sure if I’m using the right language, but I have some table relationships set up and working the way I want, but instead of listing the related tables, I would like a button that would go to the same spot as if I hit “view” on the bottom of the inline related table list. In the example below, there would be a button that said “Schools” and another for “District Directory”, but those inline reference tables would be gone.

Hopefully that makes some sort of sense! Thanks in advance.

David_Hundt

Well, I kept messing around 'till I got it to work. I’m not sure exactly why this works yet, but it is starting to make sense:

LINKTOFILTEREDVIEW(“Schools_Inline”, [Related Schools]=[DISTRICT].[Related Schools])

I think in this case [DISTRICT] is the name of the reference row? But I also have a table named DISTRICT. I think it would make more sense if I had a better naming convention.

If time allows for someone to explain what is going on in the syntax, I’d love to hear it just to grow my understanding. @Steve Thanks for getting me pointed in the right direction, as always!

View solution in original post