I have a slicer that has the vendors on it. I have two tables. 1 has the vendor name tied to the part number. The other table just has the part number only. Can I not create a relationship because I don't have vendor on both tables?

It's hard to attach the workbook because we are classified. Thank you for any help.