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: 

ProductProductNumber internalManufacturerManufacturer ProductNumberNotes
PZ2 ScrewdriverEX123Gedore6684190Good screwdriver for this or that Lorum Ipsum

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

VendorCityEmailDelivery-agreementsContact Person
ABC-Toolmaster.comStockholmABC@Example.comDelivery always carriage-paidElvis Presley
XYZ-Tools.comNew YorkXYZ@example.comDelivery always within 24hKelly Monroe
SuperOfficeSupplies.comLos AngelesSTU@Example.comDelivery always on FridayJohn Doe

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, with their price and vendor-productnumber, but also from vendor 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!

0 Replies