Hello all, Wanted to pick your brains on some DB related stuff.
Currently working on an E-Commerce site and deal with product variations (size / color - which relates to price) and was curious to know if anyone has any suggestions on table structure to best handle this, or know of any good sites with reference. Logically what takes place is a certain size + color combination constitutes the "configuration" of the product they are purchasing, as well as determines the price. Just trying to get the relationship to make sense. Thanks all, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com "We create websites that make you a hero." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
