Hi Community, I am stumped... I have a list let's call it list A with columns "GL" and "Users" (Multi user field, Users who are allowed to use the GL), I'm trying to filter a Lookup field on a Form on List B to allow selections of Column GL from List A only where Column "Users" contains "Current User". List A is on my Root site with List B on a Sub Site.
could you not just have a workflow that runs on your lookup list that assigns permissions only to those users? then the form would automatically security trim anyway?