Part info.PNG





In the attaced picture, Partnum is linked to partnum. The problem I am having is if I create a power pivot and select 'PARTNUM' from VW_Part and Prodcode from VW_Partinformation, i get all the Prodcode while I should be getting only Prodcode