Not an expert and this might be really stupid, but what is the advantage of making products with options...why not make each product option a different product? Seems it would simplify what you need to do.
Mark -----Original Message----- From: Mike Little [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2008 8:46 PM To: CF-Talk Subject: product query - need an expert help! i am stuck... ok, for my product catalogue i have included a basic inventory system. product ------------- product_id track_stock BIT stock_level INT reorder_level INT product_to_product_options -------------------------- product_id product_options_id stock_level INT reorder_level INT product_options --------------------- product_options_id product_option_title basically, if a product has options (eg. small, medium, large) then the stock is tracked at the option level. if not then it is tracked at the product level. my big problem is, how do i determine if a product is available for purchase eg. it has a stock level of zero - either at the product level or for a particular option? i need to develop a system for displaying products on a summary page. any help would truly be appreciated. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
