Hi, I have 2 datasheets.Table A has a Name column with unique names, table B has Name column with repeated names.I want to set a behavior for table A, when I select a row from table A, table B rows will be filtered for the Name column which has same names.I woulb be happy if you can help.
Create a new action and name that Action.
After creating an action, give the table name in which the action applies.
Select the action as “go to another view within this app”
And give this expression in Target(App link target) field
LINKTOFILTEREDVIEW(“Targeted view”, [NAME] = [_THISROW].[NAME])