im trying to make a database for alloy wheels. the price of these wheels will be linked to the size of the alloy i.e there might be one type of alloy wheel in 6 different sizes. so one type of alloy will have 6 different prices.
at the moment my database holds ONE price for ONE stock item. but now i can hold X amount of prices for one stock!
if it helps, my DB has an item table where all general item info is held i.e. price, description, picture etc. then each stock item is held in its own table, i.e tyres table, alloys table, etc. where more item specific information is held.
the problem is, i dont quiet know how im going to get around this problem without restructuring my entire DB! any ideas guys?