Hi, probably a simple question that I have for what I think is a simple
database. I have a Vendors table and an Items table. There is only
one items, but several Vendors may have that same item. I have to have
a third table, correct, to connect them?
I was thinking
OrderDetails (or something like that)
OrderDetailID
ItemID
VendorID
ItemSerial (I thought about this because each vendor might have the
same vendor, but different serial numbers, which I cannot put in the
items table)
Price
Purchased (y/n field)
Comments
I can then select all items and the vendors or a vendor and all the
items they sell. I really just need this simple thing. I don't need a
full-fledged inventory program. We don't need to track it like that.
It's more for initially purchasing. Sort of a furniture and fixtures
type database, but without the need for full asset management.
I thought that if I had just the two tables and put in say ItemID in
the Vendor table that I'd have duplicate rows. I'd have to type in the
vendor name each time.
Does this sound right? Thank you for any help.