Getting all the field values

(0) Share

Report

Posted on by Muhammad Anas Naeemi

436

Hey everyone, I want to ask that how can we use .get method without having the primary key. For example, if I want to enter a value in any field from the field of another table how can I do that? Make sure that I don't have the primary key. Kindly help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

you can use like below

var

Customer: Record Customer;

Text000: Label 'Customer was found.';

begin

If Customer.GetBySystemId('{5286305A-08A3-E911-8180-001DD8B7338E}') then

Message(Text000);

end;

learn.microsoft.com/.../devenv-get-find-and-next-methods

Was this reply helpful? Yes No
Suggested answer

pankaj.k 1,020 on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

if you don't have primary key Connection then you need to use Setrange & Serfilter and connect both table with the Setrange and Setfilter Method.

Please check the below link for how to use Setrange & Setfilter Method.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-setcurrentkey-setrange-setfilter-getrangemin-and-getrangemax-methods

Was this reply helpful? Yes No
Muhammad Anas Naeemi 436 on at

Like (1)

Report
Copy link

Link copied!

Hey Nitin, it worked. Thank you so much.

Was this reply helpful? Yes No
Muhammad Anas Naeemi 436 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your response. My issue is resolved. I hope your answer was also right but I didn't checked.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sound good.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Getting all the field values

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Getting all the field values

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates