How to Filter the table based on the value entered in the other table?

[jkevz07]

Hello!

I have 3 tables (Userform, Sales Report, and Collection Report). I am trying to create a filtered view expression based on the valued entered in another table.

Right now, I manage to create an action which allow me to select which report it will navigate (please see below photo). This is my expression: IFS([TYPE OF REPORT] = "Sales Report", LINKTOVIEW("Sales Report"), [TYPE OF REPORT] = "Collection Report", LINKTOVIEW("Collection Report"))

What I am trying to do is whatever month and type of report I selected in my Userform will navigate and filter the values in the Sales Report or Collection Report by month. (Please see below photo's of my UserForm and Sales Report Table)

[Comercial_Maqst · Accepted solution]

You should use the expression "LINKTOFILTEREDVIEW" according to the parameters you want.

Create a Detail view, don't use a form. In detail view use quick edit and create one action to the LINKTOFILTEREDVIEW.