I have imported two content types. One is for a vendor list and the other is for a contact list. The vendor list was imported with a vendor id column. The contact list was also imported with a vendor id column that indicates which vendor a contact is related to. A vendor also has many contacts.
I have added an entity reference field to the vendor list referencing the contact list but I don't see a way to link the vendor id columns together.
I have also tried to use an entity reference view with a relationship and contextual filter.
The result I get is an empty contact list for each vendor.
I have read many articles and watched several videos but I haven't found one that pertains to my situation.
How do I get these two content types to reference each other via the vendor id? Do I need to go about it a different way? Is there something I am missing when setting up the entity reference?