Conditionally counting records based on field on new record

Yes. I had already implemented the third table approach but it was just looking too cumbersome and clumsy. As of now I don't see a native way to easily accomplish this. But who knows? It may come to me.

Thanks again.