Im trying to create a program that I can offer package deals for items that are ordered, but not hard code them into the program itself. I have a table set up with product codes, not all the codes are part of a package and some can be part of more than one package.

Example:
prod1 when ordered by itself is $25.00
but when ordered with 3 other items its a flat $40.00
and then $10.00 each for any additional item up to 6 items.

I would like to set this up so that it doesnt have to be programmed in, but just added as other package deals are offered.

Im at a loss as to how to set up something like this, any ideas that could send me in the right directions would be greatly appreciated.

Thanks
Ron