>>Rather than deleting a record, flag it as "inactive" and adjust other queries only to look in records flagged as "active". This is nice because if someone screws up, you can roll it back.
This feature was standard in dBase, Clipper, Foxpro and al. I wonder why is has not been kept in more modern databases and SQL. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com