Show field from related table in List page

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all

Pretty new to Nav development and creating my first extension. Got most of it working and now improving things.

I have a custom list page that displays a list of sales orders based on a filter. All works great. Right now it displays the Shipping Agent Service Code, but I want it to show the description from Shipping Agent Services instead.

I know I need a table relation, but not sure how to reference the field in the related table (Shipping Agent Services)

field("Shipment Method"; "Shipping Agent Service Code")
                {
                    ApplicationArea = All;
                    CaptionML = ENU = 'Shipping Agent Service Code';
                    Editable = false;
                    TableRelation = "Shipping Agent Services";
                }

Could someone point me in the right direction?

Thanks

Mark

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Show field from related table in List page

Hi Mark,

You might want to create a flowfield as a table extension for Sales Header table to host the description of the Shipping Agent Service. The Shipping Agent Service Code is a 10 character long CODE field and as such not suitable for the description field. Then you need to add the flowfield as a field to your page extension and possibly call a Calcfields function for the new flowfield to the OnAfterGetRecord of the page extension. Not sure if the last bit is needed, haven't tested that.

Let me know if you need help with the flowfield. Seems like have the rest figured out.

Tero