Mark,
Thanks for the help I switch it to TABLE buffering before the BEGIN TRANSACTION. I'm beginning to like this VIEW stuff after all. I didn't use it in 3.0 because of legacy code and sharing with DOS. However, by 5.0 I had created so much code that switching was going to be too time consuming. Now, I'm biting the bullet to prep for future SQL Server work.
I have been doing all kinds of trials and tribulations trying to figure out the best ways to do things.
Congrats on the upcoming boy as well. My niece cried and cried when my nephew was delivered because she wanted a sister as well. It took several hours to calm her down. She kept telling my sister to send it back! Send it back! :-)