I think I follow what you are doing. Yes, that would cut down on the number of cursors. The 'h' after some of the table names is to indicate it is a history table. It is to keep the file size down on the tables that the customer uses the most.
Thanks,
Derek Agar
Acctware Business Systems
derekagar@acctware.comICQ: 42332100
***********************
When in trouble call 911
He that dwelleth in the secret place
of the most High shall abide under
the shadow of the Almighty.
Psalm 91:1
***********************
