Restrict Lookup Value Based on Current User Level

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
aspsteve
User
Posts: 52

Restrict Lookup Value Based on Current User Level

Post by aspsteve »

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


MichaelG
User
Posts: 1095

Post by MichaelG »

Use the Lookup_Selecting server event. Read:
https://aspnetmaker.dev/docs/#/customsc ... _selecting


Post Reply