I have one list, called as "Approvers"-It has around 20 names in it.
Logged in user might also be one of the approvers in the above list.
I want to populate above names to be populated in list lookup control eliminating logged in user. That is "Created By" cannot select themselves as approver.
Is it possible ?
Hi Michael, Thanks for the reply. I dont think calculated will help, because i need list of approvers to select from, not just one single value. Neither can i disable the control, because if i do that how will approver be selected then.
I got you.. I already have the current user in calculated column, but my concern is how do i apply filter in list lookup control to eliminate current user form list of approvers.