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

I can't pickup field County from a code lookup that refers to Post Code Table AL

(0) ShareShare
ReportReport
Posted on by
Hi,
AM trying to lookup field "county" from post code table using the code field so that after successfully picking the code field in my page the county field should populate from the post code table.
When I lookup the code field in my page, the break point sets its self on vscode on the line that's lookin up. And when I go back to BC page, my page hangs and displays a message "working on it". Below is an extract of my code.
pastedimage1599925366582v1.png
I need to pick the field county on page. Kindly assist?
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    159 on at

    Primary key on that table is code and city. It hangs as it doesn’t have all the data to perform the get.

  • Suggested answer
    Jyotsna NAV Profile Picture
    585 on at

    Hi, 

    You can only GET primary keys. If you want to use other fields then SETRANGE and FINDFIRST (based on your scenario)

    Regards
    Jyotsna
    jyotsnanav.blogspot.com

    Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.

  • Romryan Profile Picture
    on at

    Josh,

    If a table has a composite keys as you have mentioned, how do I use code and city in get method so that I can pick the field County on a separate field after looking up the keys field(s). Am new in Busness Central/Nav.

  • Romryan Profile Picture
    on at

    Jyotsna,

    Am new in Nav/Business Central and am open to adopt you suggestion too. Will you mind giving an example?.

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 Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,353 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,808 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,371

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans