Data duplicating in table when using two datasets

I have main dataset and I am trying to create an excel file that i input some additional adjustments in and i am linking the two files by a unique material identifier. The relationship is one to many.

When i go to try and build a table with data from both datasets the numbers are not showing correctly. I am not sure what i am doing wrong.

For context: the excel file, that i am linking to the main dataset, currently has one row and three columns. The columns are the unique identifier, another identifier and the adjustment amount. For whatever reason when i put the adjutment column in the table the number is showing up under all material numbers instead of just the one from the excel file. I highlighted the one where it should be. The highlighted column is coming from the excel file while the other columns are coming from the main dataset I am using.  In theory, it should show zero for all rows except the highlighted one. 

What am i missing?