how can I join 2 DATA SOURCES and it will pull from only one

​@SandyA What you’re seeing is a join type which is considered a ‘one:many’ (one to many) type relationship. There can be multiple lines on an SO, so by joining SOOrder to SOLine you’re getting a result for each line on the order. This may not be a problem and all you need to do is add a grouping on the SOOrder.OrderNbr and then it will lump all into one line.

This can cause a problem though if you are also displaying the order total and it’s appearing on each line because if you group it will SUM the values and then the order total will look overstated, so instead you’d need to display the line amounts and then once they are summed it will have a normal amount.

I also can’t tell in your relation if you’re adding OrderType to the data links for the join on SOOrder to SOLine. It’s important to make sure all key linking fields are used if possible and for SOOrder you’ll always need to have OrderType and OrderNbr in the links.

Hope this helps!

can you give an example of how i will write the Group, for the SOOrder.OrderNbr

​@SandyA Just add SOOrder.OrderNbr to the grouping tab in the GI setup screen:

thanks a lot, you the best. i got it working now

I have come to this issue that you mention. How to I fix it. Can you give a example.

“This can cause a problem though if you are also displaying the order total and it’s appearing on each line because if you group it will SUM the values and then the order total will look overstated, so instead you’d need to display the line amounts and then once they are summed it will have a normal amount.”

thanks