I'm having a little trouble with a project.
I need to display a spreadsheet like set-up with product names on the left; quality types along the top; and the user fills in the product quality scores. The products are foods and the qualities have to do with taste, texture, etc. The user will then score each product 1-10 using a select drop-down. (DD indicates a drop-down) PRODUCTS----Q1----Q2----Q3----Q4 PRODUCT1----DD----DD----DD----DD PRODUCT2----DD----DD----DD----DD PRODUCT3----DD----DD----DD----DD PRODUCT4----DD----DD----DD----DD There are currently 23 different quality types per product with usually no more than 10-20 products per "spreadsheet." There are 100s of evaluators. After the evaluation quality control people will be able to review the average scores. The db is relatively simple (see below), what I'm having problems with is the display. I've gone around in circles. DB (simplified version) PRODUCT QUALITIES PRODUCT_RANKINGS productID qualitiesID rankingsID productName qualitiesName productID qualityID userID productRankingScore thx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
