User Setup

(0) Share

Report

Posted on by jsshivalik

3,099

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

I have the same question (0)

All responses (1)

Answers (0)

mmv 11,471 on at

Like (0)

Report

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.

Was this reply helpful? Yes No