>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
Sounds like you need to analyze all the possibilities to come up with a data model of the scenarios, then create your tables and SQL statements based on the data model. This could take some time, but it's the only way I know of going about it.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.