Linking of sharepoint lists cross-referenced

Hi all, 

I'm all new to sharepoint and trying to create a site/portal which will be used as some kind of database for products, vendors, and possibly later also storage-locations within our company. 
To shape this, i'd like to take the following approach: 
First, a List about products used in our company, in this example a screwdriver is listed: 
PRODUCTLIST

 
Than, a seperate list with all vendors used/known within our company: 
VENDORLIST

Now the tricky part, i'd like to make a connection between these two lists. Example situation: 
Our purchaser sees need to buy (internal)product number EX123 (which is a Gedore 6684190 screwdriver). For this, he looks at the productlist and then should be able to see that this product is available either from vendor ABC-Toolmaster.com, with their price and vendor-productnumber, but also from vendor XYZ-Tools.com with their respective price and vendor-productnumber.  

That said, i'd like to make a reference containing data from both tables, and some extra info (vendor-productnumber, price, etc.). Offcourse this info should be entered when creating a new product. 

I'm not really getting how to implement this without having double-data or limited amount of vendors per product, hoping anyone over here could point me in the right direction on how to accomplish this. 


Thanks in advance!