Auto filling fields on NAV

(0) Share

Report

Posted on by Community Member

Hi ,

I created two tables on NAV Policyholder Table and Insurance invoice both with the No. and Name fields, when i select the No. field on my Insurance invoice table i want to see all my Policyholders and when i select a policyholder no i want his name to pop-up in the insurance invoice field (Name). i already set table relation of my insurance invoice to look up to the policyholder table and i tried to use the .GET function to retrieve the "name" from the policyholder table but its not working, here's the sample of the code i added to the onvalidate trigger of the No. field of the insurance invoice table

InsuranceInvoice.GET(PolicyHolderTable."No.");
InsuranceInvoice."Name" := PolicyHolderTable.Name;

Please help!!!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

PolicyHolderTable.GET("No.");
InsuranceInvoice."Name" := PolicyHolderTable.Name;

InsuranceInvoice.Modify;

you need to get the No. first from PolicyHolderTable

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello, Its not a big deal.

Try #mohana suggestion.

and for Lookup and populating Just see the Table 18 and Table 36.

Like Table 18 you have to create a Field Group on Policyholders Table so whenever you you select the No. field on Insurance invoice table, you will get Policyholders.

Assume Policyholders table is like Customer Table 18

and Insurance invoice is like Sales Header 36.

See the Sell-to customer no field in Sales Header Table

You can also use VALIDATE function.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Check out this link please.

www.archerpoint.com/.../customizing-drop-down-lists-tables-nav-role-tailored-client

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Already tried this, didn't work

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

For more help you can check how standard Navision works

Check in Sales Header--> Sell-To Customer No field You will get an idea to navision populate field

Was this reply helpful? Yes No