Forum Discussion
mohit_K
Helper I
Helper IRow Level Security using Two Tables
I have a Data Table as shown below :- Territory ID Value SKU ID 1 11 22 1 22 23 1 33 22 2 44 23 2 55 22 2 66 23 3 77 24 3 88 24 3 99 22 4 12 25...
HI mohit_K,
Perhaps you can write two search expressions to lookup values from different tables to get 'SKU id' and 'Territory id' based on USERNAME function.
Then you can use filter both two fields with 'OR' logic on the 'mapping' table at the same time.
Regards,
Xiaoxin Sheng