LINKTOROW question

[NCD]

Hi,

I have a Year Table in Table View, and a Product Table in Table View.

When I click on a specific Year, I would want only the Products made in that year to show up.

I created an action;

For a record of this table: Year Table

Do this: App: go to another view within this app

Target: LINKTOROW (id, "ProductTable's View Name")

Under Product Table View In UX pane I've changed the Event Actions to the one I've just created, but still shows me every product from every year.

What am I doing wrong??

[TeeSee1 · Accepted solution]

You are going from the Year Table to the Product table.

So the "id" in your LINKTOROW means the id (key?) of your Year Table.

So it is trying to match the Year Table's id to the Key of your Product Table, which is, I am guessing, most likely not what you want. (year : products = 1 : n )

Try

LINKTOFILTEREDVIEW( "ProductTable's View Name" , [year] = [_THISROW].[year] ) where

the first [year] is the year col in the Products and the second [year] in the Year table.

[NCD]

Thank you, worked perfectly~!