nelsonm - 6:37 am on Jan 26, 2012 (gmt 0)

thanks for responding...

ok, let me see if i got this straight...

Customer data
Address data is no longer included in the customer table and is now a separate table. The link between a customer and past/present address is now maintained in the customer's work order table record as - say - fields [CUSTOMERID] and [ADDRESSID]. That way, all existing/past customers work orders point to the correct address. The from and to date added to the address table allows you to find the current address.

Wouldn't you want to have a customer ID field in the address table that points all address records for a particular customer back to the customer? With out that, you'd never be able to tie/display customer records with all associated addresses or even the current address.

Work order and pricing data
I understand the idea of the from and to date. But rather then having a multiple item/price records for a particular item, wouldn't it be better to separate the service items from their pricing and instead have multiple price records with from and to date fields to indicate the current item price? A work order items table would then keep track of the [ITEMID] and [PRICEID]'s associated with the work order.

your thoughts...