nelsonm - 11:26 pm on Jan 26, 2012 (gmt 0)
So you advocate a method that does not require a separate customer address table or a price list table that maintains archived records.
In your schema, you simply create a work order record in the work order table that links to ancillary static customer and items tables. These static tables maintain a snapshot of the customer and item/price (just the items/prices of the stuff the customer purchased) data at the time the work order is generated.
The main customer and pricelist tables do not contain archival records and are simply updated as required to reflect current customer and pricing data.
Am i correct?