Hi there,
I'm new to access so bear with me, I appreciate any help I can get!
I've been tasked with creating a database that would be able to combine all of the price sheets that my company receives from vendors into one database where we could see a list of the part numbers we use, along with the prices that each vendor provides for that product (if any - not all vendors will sell us each product.)
Each product has a part number that we use that for these purposes I'll call its "Product Key." Sometimes when vendors give us price sheets they list the parts along with their "Product Key" number, but sometimes they just use their own sales number or the original manufacturer's part number. This is fine, as we have an interchange spreadsheet that lists all of the manufacturer sales and part numbers along with their appropriate "Product Key" number. Each sales number is linked only to one product key number, but one product key may be linked to multiple sales/manufacturer numbers.
I have the database set up with all of the information on different sheets, with a separate sheet just listing our full inventory of items listed by "produt Key," with this being the primary key and the product keys on all of the interchange/sales sheets being the foreign key. I guess I'm wondering, broadly, what relationships and queries I should have set up so that I can create a sheet with all of our inventory, listed by product key, along with any price that a vendor might provide us with for that part, even if they don't give us the product key right on the sheet and we have to use our interchange data. Again, sorry, like I said, I'm brand new to database design, I'm actually a graphic designer who has been asked by my employer to figure this out and have so far just been Google-ing Access tutorials, so I'd be grateful for any assistance.
Krystal