Help with tables.

[Christi Lee]

Hey you guys. I'm really stuck. I am trying to design tables for work.
The problem is that there are several vendors/suppliers that have a different
price for the same product. You figure out the the price by the number of
miles.
I am trying to figure out how to add this without having to make a table for
each vendor with the same information except for the price? There is also
cost charges and price charges for each vendor. Any ideas??

 

[Duane Hookom]

I expect you need a junction table like:

tblVendorPrices
================
VendPriceID autonumber primary key
VendorID
ProductID
MinMiles
MaxMile
Price

 

[Christi Lee]

Thank you duane for the feedback. This looks good and helps me to understand
better what I need to do for the mileage. Thank you much !!!