Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Select Value for a Fie...
Microsoft Dynamics NAV (Archived)

Select Value for a Field into Development NAV --> Pages

(0) ShareShare
ReportReport
Posted on by mak97 7

Hi Everyone. 

I hope that you can lead me to the right way,  i am newbie person using NAV 2015 and i dont figure out how to fill a field with the Developer Environment.

I have created 2 new fileds within the DB and now i am using them in the page for purchases but i dont know how to get the value from another table in automatic, until now all that i could do is get the values but i need to display the options to select it.

and i need fill that filed automatic.

In the properties control in the files i use the option "TableRelation" 

IF (VAT Retention=CONST(RETIVA10)) "VAT Posting Setup"."% Ret. VAT" WHERE (VAT Prod. Posting Group=FIELD(VAT Retention))

Field.png

Best Regards from Mexico

Roberto Campos R.

*This post is locked for comments

  • mak97 Profile Picture
    mak97 7 on at
    RE: Select Value for a Field into Development NAV --> Pages

    Thanks a lot for your information

  • Suggested answer
    Olister Rumao Profile Picture
    Olister Rumao 3,957 on at
    RE: Select Value for a Field into Development NAV --> Pages

    Hi Roberto,

    From what I can understand, you have added 2 fields, one of which contains a drop down.

    When I select the value in drop down then automatically second field should be filled with some value.

    You can do this.

    On the first field set the table relation property to get the drop-down from whichever table your want.

    On the same field there is an OnValidate trigger which will contain code to automatically set the second field.

    Let me know if you need further help.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 44,634 on at
    RE: Select Value for a Field into Development NAV --> Pages

    You create the field as FlowField of type Lookup and use that formula on it.  Please check below link for more information

    https://docs.microsoft.com/en-us/dynamics-nav/flowfields

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans