I'll try to keep this short. I'm creating a digital version of a paper system in our consignment business. Using SQL Server.
1. We fill out a form showing the customer what we're sending them (startQTY), and productprice 2. They sell whatever, then send back the form filled in the with the endQTY, totalsold, totals, etc. I've gotten a good bit done but running into an issue now. I'm using CF to calculate some of this stuff and I know I probably should let the db handle it but it's just too easy. On the extended prices for each item in a row, I'm currently calculating as it displays out on the page, but I need this to be logged in the db. It'd be a little cumbersome using that same tblConsignOrderItems to hold this data because we don't know what the extended prices even ARE until they ship back what they didn't sell and we fill out the form. So should I create a view of some kind to count up the extended price for a particular item, after we've filled out the form? And if so, can someone gimme a simple example. I'm gonna do some googlin' and lookin thru my books. Just wanted to make sure I'm even on the right path here. You can see a screen cap of my display page. The db schema is just like a regularproduct db. You have a consignment order that drops a FK into the consignment order items table. Then everything is grouped into categories, since multiple products can be in a given category. http://wtomlinson.com/consigncap.jpg Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
