News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How do I get the value...

Finance | Project Operations, Human Resources, ...

Answered

How do I get the value of a field from a datasource that has a relationship with the main datasource?

(0) Share

Report

Report

Posted on by Pavel Ioana

102

I need to validate if the selected lines in the BOM have the same WHS. I noticed that the ProdBOM table has a relationship with the InventDim table, but the relationship is based on the InventDimID field that also stores information about InventSiteId. I need to check if the InventLocationId is the same for each line. How can I do this? The code is written in the active method.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Martin Dráb 231,430 Most Valuable Professional on at

Like (0)

Report

RE: How do I get the value of a field from a datasource that has a relationship with the main datasource?

Simply find the InventDim record for the given InventDimId and look at the InventLocationId there.

By the way, I don't understand what problem you have with InventSiteId. If InventLocationId is the same, InventSiteId must be the same too, therefore it doesn't change anything.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,430 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans