Restrict Lookup Value Based on Current User Level
Posted: Thu Apr 06, 2023 7:47 pm
One of my lookup tables has the following fields
[StatusID]
[ApprovedLevelName]
[ApprovedLevelID]
[AvailableStatus]
I would like to restrict the displayed lookup values available to the user to the list of AvailableStatus that corresponds to thier CurrentUserlevel (ApprovedLevelID)
I tried the following code in the filter field
"AvailableStatus Where CurrentUserLevel() IN ApprovedLevelId "
I know it is bad code and I need some help