If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with tables.
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?? -- Christi Lee |
#2
|
|||
|
|||
Help with tables.
I expect you need a junction table like:
tblVendorPrices ================ VendPriceID autonumber primary key VendorID ProductID MinMiles MaxMile Price -- Duane Hookom Microsoft Access MVP "Christi Lee" wrote: 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?? -- Christi Lee |
#3
|
|||
|
|||
Help with tables.
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 !!! -- Christi Lee "Duane Hookom" wrote: I expect you need a junction table like: tblVendorPrices ================ VendPriceID autonumber primary key VendorID ProductID MinMiles MaxMile Price -- Duane Hookom Microsoft Access MVP "Christi Lee" wrote: 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?? -- Christi Lee |
Thread Tools | |
Display Modes | |
|
|