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

(0) Share

Report

Posted on by Pavel Ioana

106

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.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 236,552 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.

Was this reply helpful? Yes No