Hello, I have three tables. Main data table (sheet1) has multiple
location_uid rows, other one has unique list of [location_uid] and a corresponding regular address ( [loc_name] ) in same row. I created an enumlist dropdown of unique regular addresses in a v.column and let user select the location. I record user’s selection to a different table (settings) in same workbook. I want to filter main data table rows with security filter based on what’s selected as location, in (settings) table. So the selection will serve like a master switch and keep other records invisible across all functions in the program. I thought of using ref columns but in my case it seems I will need reference of reference which is not possible, according to some help page. The data table (sheet1) has location_uid but not regular addresses. Is it possible to solve this without adding the address column into sheet1?