Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / User Setup
Microsoft Dynamics NAV (Archived)

User Setup

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,099

Hi

  I have field on Request Page . In properties on Table Relation i have given below code

"Dimension Value".Code WHERE (Dimension Code=CONST(CostCENTER)) . In Dimension Value Table there is field Shortcut Dimension 1 Code.

In User Table Setup i have fields Location1,Location2,Location3,Location4,Location5. User may have access to 1 or more Locations.

I want only those records from Dimension Value which have Shortcut Dimension1 Code = Locations from User Setup
. If User has Location2 , Location3 then only those records are displayed from Dimension Value which have ShortCut Dimension 1 Code = Location2 & Location3

Thanks

*This post is locked for comments

  • mmv Profile Picture
    mmv 11,467 on at
    RE: User Setup

    You cannot use the table relation property.

    you need to write the code in the "Shortcut Dimension 1 Code" OnLookup trigger on the RequestPage.

    The filter should contain:-

    "Dimension Value".SETFILTER(Code,'%1|%2',UserSetup.Location2,UserSetup.Location3);

    In the last post, I have explained to you how to code in the OnLookup trigger.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans