Make sure you have your VendorID set as the same datatype in both the tables.
N.B: Even if it is stored as a number, make sure they are both long integers. The duplicates shouldn’t prevent you from creating a relationship: duplicates restrict only when you try and create a relationship with referential integrity.