News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Link Packing slips vs ...

Supply chain | Supply Chain Management, Commerce

Suggested answer

Link Packing slips vs Load in a form

(1) Share

Report

Report

Posted on by D365 beginner

576

Hi Experts,

I need to build a form where I should display all sales packing slips along with their load details. I was trying to add below 3 data sources in my custom form and join them to get it done. I am not getting the results as expected as the joins does not work properly it seems and it simply shows all the packing slips posted. Can anyone help me how to join them in a form and whether it can full fill my requirements.

All responses Img

All responses (2)

Answers Img

Answers (0)

Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (0)

Report

Link Packing slips vs Load in a form

Can you show us the types of joins you did between those datasources?
Suggested answer

Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

Link Packing slips vs Load in a form

Adding data sources isn't enough; you must also set their properties accordingly. The Join Source property defines a parent data source of a given data source. The Link Type property defines the type of join (e.g. Inner Join) or link (such as Delayed). There should be a relation between those tables, if it doesn't exist and can't be added, you can add a link or a dynamic link in code.

Also, just checking whether you're getting correct data or not is not a sufficient way of debugging of a query. You should look at the actual query used by the form, because it'll give you details such as whether joins are in place, what join conditions are used and so on.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans