> I feel it's ridiculous to track changes to fields BEFORE the complete data > set (form) is submitted, unless that is a specific intention of the business > logic, which I don't think in this case it is.
Basically, ADMIN sends an email to all the sys managers that have systems listed in the database. The sys managers have 20 days from the time the email notice is sent to complete their information. After that they're automatically locked out. ADMIN logs in and can see all the data in the current record for each sys manager, but also needs to see a log of the changes each sys manager made each session over the 20 day period. The entire project is finished using pretty much standard CF code for multi-page forms (or my weird version of it anyway) - they requested the "change log" after the fact. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4