web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Retrieve record base o...

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

Suggested Answer

Retrieve record base on secondary key

(0) Share

Report

Report

Posted on by donghoang

50

Dear team,

How to use Get Method to retrieve record base on secondary key. I already use setcurrentkey before get method but it still not work.

TestField("Receiving No.");

QCHeader.SetCurrentKey("Receiving No.")

if ("Receiving No." <> QCHeader."Receiving No.") then begin

QCHeader.Get("Receiving No.");

end;

Warm Regards,

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

JAngle 133 on at

Like (1)

Report

GET is primary key only. Try one of these other methods: docs.microsoft.com/.../devenv-get-find-and-next-methods

It’s common to just setrange on which fields for your record variable and then state if qcheader.findfirst then

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,606

#2

YUN ZHU 931 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans