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
Good screwdriver for this or that Lorum Ipsum
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.