Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Look up from a field

Look up from a field

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,
How do I look up from a field(''No.'' from Customer table) on a request page of a report?? I have already created a filter based on this field on request page.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Look up from a field

Selec the field on the Request Page of the Report and in the Properties in the TableRelation add the condition or table

Customer WHERE (Location Code=CONST(TEST))
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Look up from a field

Hi Rajat,

You can write following code OnLookup Trigger of the field created at Request Page.

IF PAGE.RUNMODAL(PAGE::"Customer List",Customer) = ACTION::LookupOK THEN BEGIN

CustomerCode := Customer."No.";

End;

Hope this helps.