table setup question

[Boze]

I'm working on a db of our companys Items. So far I have;

tbl Items - ItemID (pk), Item Name, Item Sales Price, etc
tblVendor - VendorID (pk), Vend Name, Vend Phone
tblItemsVendor - ItemID (pk), VendID (pk)

I have the info in a form based on Items with a subform for Vendors
(sometimes we get an item from more than one vendor)

My question - How do I list the item-specific info for a vendor?

For example.. we get Widgets, our part number WIDG001 from
- Acme Supply, their part number W1234, their price to us $.02
- Bubbas Wholesale, their part number BBWidg, their price to us $.015

When I look at my Item form I can now see the vendors in the subform. I'd
also like to see the vendors part number and price for that item. Can I put
this info in tblItemsVendors somehow? I'm not sure what search term(s) to
use to find this on my own.

Thanks in advance

 

[Bill Edwards]

tblItemsVendor - ItemId, VendId, VendorPartNumber, VendorPrice

 

[Boze]

It's that simple and straightforward? That's too cool!
Thanks!
Boze