Small and medium business | Business Central, N...

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

(0) Share

Report

Posted on by Romryan

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.

I need to pick the field county on page. Kindly assist?

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Romryan on at

Like (0)

Report

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

Jyotsna,

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

Like (0)

Report

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

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.
Suggested answer

Jyotsna NAV 585 on at

Like (0)

Report

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

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.
Suggested answer

JAngle 95 on at

Like (0)

Report

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

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