web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Read-only field in page that looks up value from another table

(0) ShareShare
ReportReport
Posted on by 89

Hello, I am trying to create a field in my Purchase Orders page that looks up a value from another table, based on the Vendor No. field, like below.

pastedimage1664998575807v1.png

(Purchase Order page, with Payment Terms Code looked up from the Vendor table. It should be Read-Only.)

I haven't been able to figure out how to accomplish this, and my googling has been unfruitful (not sure what it's called). I looked up the base application code for Vendor Name and No., but it hasn't helped.

pastedimage1664998726425v2.png

Any advice? Thank you.

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    102,389 Super User 2026 Season 1 on at

    Hi, Here are some simple solutions that hopefully give you some hints.

    https://yzhums.com/22220/

    And

    How to create a Lookup, Drop-Down, or Option list

    https://yzhums.com/5985/

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Hi,

    On that field you have to use the Trigger OnLookup and then write your code to open the particular page, based the filters.

    Thanks.

  • matthewjd24 Profile Picture
    89 on at

    Hi, thank you for the reply. I have a question about the second link you sent. I was going to do this but how can I set the trigger OnValidate() if the field is one of the default fields in the page? How can I add that to the field? In this case, it is the Vendor No. and Vendor Name fields. Thank you.

    pastedimage1665369072429v1.png

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 653 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 414 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 394 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans