Just like I have to store the Product Description in the InvoiceDetails table instead of relying on the
current description in the Inventory table. Why? Because their distributors are constantly
tweaking the descriptions. Sometimes they even change the size without creating a new item number. Wreaks havoc on their inventory control.
Mark McCasland
Midlothian, TX USA