Ahh figured it out..
I just needed to create a relationship between the part name between the 2 tables. As the part name is the main filter (only 1 record of that particular name) you just need to use that so it can detect the correct weight.
You might want to use a Part Id instead of a name. You never know, at some point someone might decide that a part should be named differently and want to change the name used.