Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Auto filling fields on...
Microsoft Dynamics NAV (Archived)

Auto filling fields on NAV

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Auto filling fields on NAV

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto filling fields on NAV

    Already tried this, didn't work

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Auto filling fields on NAV

    Check out this link please.

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

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Auto filling fields on NAV

    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.

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Auto filling fields on NAV

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

    InsuranceInvoice.Modify;

    you need to get the No. first from PolicyHolderTable 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans