Tom - Thanks for the idea. I will have to think this over and try going down the path of using count columns in the Service table and Triggers.

I definitely agree that I should maintain integrity in the database, I just wasn't sure how I would do it.

I will try this.

The count column idea actually could work for another business rule that I didn't include in the example.

If anyone else has other ideas, please add your thoughts. It will probably be a while before I implement any change.

Thanks again.