Is the correct solution?

[ricpa]

For my shopping cart some products have a minimum order amount and then have discounts for certain amounts over that minimum. E.g. Minimum order of 100 - £5 each. Order of 125 - £4 each. etc.

Should I create a table with each product id that has this type of order and set fields for these amounts and prices and then call them into the recordset?

[Bullschmidt]

I'd try to go with one table:

ProductID
Qty
Discount

Here is some sample data:
12345BC 100 4
12345BC 125 5

And this means that for product 12345BC if the user chooses 100 to 124 items then he gets a $4 discount on each item. If he chooses 125 or more items then he gets a $5 discount on each item.