Microsoft Dynamics NAV (Archived)

Add field to form from another table

(0) Share

Report

Posted on by Angel Arteaga

159

Hi NAV experts

I have the following requirement:

On the Items pane I can see Item's price by vendor with the following fields

"Item No.", "Vendor No.", "Direct Unit Cost", etc

My question is... how can I add the vendor name field on that form?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Angel Arteaga 159 on at

Like (0)

Report
Copy link

Link copied!

The form that I'm trying to modify is "Purchase Prices (7012)"

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

You can create new flow field "Vendor Name" in Purchase Price Table (Table ID - 7012). Refer below screen shot.

Later you can add this Vendor Name in Page 7012 - Purchase Prices.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,941 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hey Angel,

You have two solution here.

1. Add a Field in the Purchase Price Table. - "Vendor Name". Write this code on the OnValidate Trigger of Vendor No.

Vendor.GET("Vendor No.");
"Vendor Name" := Vendor.Name.

Vendor is the the Varibke referencing Vendor Record.

2. Add a Varible in the Form and Name it as "Vendor Name". Write this code on the OnAfterGetRecord of the form.

Vendor.GET("Vendor No.");
"Vendor Name" := Vendor.Name.

Add Vendor Name in your Page.

Was this reply helpful? Yes No
Angel Arteaga 159 on at

Like (0)

Report
Copy link

Link copied!

Thanks both for answer the Variable solution works great

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

You can also add a Vendor Name field in the Purchase Price Table and define it as a FlowField, that would LookUp by Vendor No. in the Vendor table and take the Vendor Name from Vendor Table.

That would not require programming as such, and enable the Vendor Name in all current Purchase Price tables. But, beware that adding too many flowfields can degrade database performance.

Was this reply helpful? Yes No
Angel Arteaga 159 on at

Like (0)

Report
Copy link

Link copied!

Thanks for help, I tried this way too, but my license don´t allow me to add fields to Purchase Price Table.

So I decided use a variable in the form

Thanks again

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

If you try creating field in 50000 Series, it should definitely work in your license as well . Check the screenshot attached in my earlier thread.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

Angel, you should be able to create additional fields; try putting all your additional objects within 50.000+ objects range. It is the range for additional objects for users.

Was this reply helpful? Yes No