Relationship issues

[SAGUILAR]

Hello,

I have the following table (Left) which contains two columns Material and Batch#, the column "Qty" is coming from the same table as the batch # and "Sum Unrestricted" is coming from a different table, the goal is to compare the qty available at batch level but the column "Sum Unrestricted" is showing the result for the material not for the specific lot that I need. As you can see on the right table, the sum of all the lots is 10820 but the correct total should be 1320. How can I get the result for the lot# only showing on the right table?

Thanks!!!!

[PhilipTreacy]

@SAGUILAR 

Can't help without seeing your data and file.  Without these, can't see what is going on in the model.

Phil