|
| 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
February 24th, 2009, 01:54 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
February 24th, 2009, 02:55 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
February 25th, 2009, 06:28 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
