Hi there,
i ve been learning Dynamics nav programming for 3 days now and run into the following issue: I have a table with two fields which both relate to another table "user". The Goal is to choose a user in field 1 und choose a second user in field 2, but the user which was selected in field 1 then shouldn´t be an Option to select in field 2. I am running out of ideas so please help me. Much appreciated! Thanks!
*This post is locked for comments
Thank you very much for your quick help! Saved the day!
You are able to define a conditional filter in the OnLookup-trigger of a field.
Try something like this:
Share
Report
All responses (
Answers (
UserRec.SETFILTER("User ID", '<>%1', "Your 1st User Field");
IF PAGE.RUNMODAL(0,UserRec) = ACTION::LookupOK THEN
"Your 2nd User Field" := UserRec."User ID";
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156