Jim,
Thanks. That makes alot of sense.

FYI, prepare for more of these normalization questions over the next week or so. This is the first time I FINALLY get to build my own database structure after working with a large system for two years that was not normalized or adminstered properly.

>Jim,
>
>If you include the field for the customer screen only show it in the customer screen and don't use that field anywhere else. You might also want to include a button in the customer screen to recalc the YTDSales.