Depends how often they want to see the order history. If very infrequent, then use a history file. If sometimes or often, keep an operational history by end-dating and inserting on every update.
-----Original Message----- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 6:07 PM To: CF-Talk Subject: Logging shopping cart orders hi guys, my client wishes to be able to modify orders received from customers (add line item, edit line item, delete, modify freight etc.) - currently they can only view the order made which is very limiting. i have now made it so they can modify all details of an order, however i wish to retain the original order information somehow. should i look at logging this original information to a text file somehow? should i duplicate the order in a new table?? i am a bit stuck, so any ideas on what path i should take would be really appreciated. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244739 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
