-- On Fri, 10/31/08, Mike Smith <mikeosmith@xxxxxxxxx> wrote: > [INVENTORY_TABLE] > fields example data > part 1027P > serial 543221-K > qty 120 > location G-5 > > I'd like to record what changed. Let's say they > change the serial. One way > would be a "static" changes table: Another way is to never change a record, but to add new ones. You also need to add an effectivity date field. Stephen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
