pietlinden, just to let you know what I did and it works fine, I used a trigger instead of a sp. The only problem I have now is trying...

Thanks a million and I understand about the learning. Appreciate the help.

pietlinden, I trust I am not getting outside the scope of what I should be asking. I appreciate the example and think I can work it out. However,...

pietlinden, do you mean for me to physically check to see what the count is, or to write the check into the store procedure some way?