Thanks mary, I think this is the way I will head - 2 different table setups.
mike -----Original Message----- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Wednesday, 23 November 2005 5:37 a.m. To: CF-Talk Subject: Re: Shopping Cart - Coupon/Discount >i am a bit stumped as to whether i should be looking at one set of >tables to handle all the options above, or whether i should create to >distinct sets to handle either a discount scenario or a free product >scenario. >From my own experience, I would say to go with a different set of tables/settings. One for discounts and one for promotions (free items). You could certainly try to do it in one table, but the information you need for each of these, and the calculations involved are somewhat different. -------------------------- Mary Jo Sminkey http://www.cfwebstore.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
