I would make a history table. In there I'd probably do it one of two ways. 1) The History table would have HistoryID, OrderID, FieldChanged, OldValue, NewValue, and DateChanged. 2) I was interrupted by a call and I just got off the phone so I forgot #2. :-) If I remember, I'll email later.
Hope this helps. On 6/23/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote: > > 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:244705 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54