Well, for some reason I just didn't think this one through. If I had to do this from start, the CaseClosed flag wouldn't exist in the Case table at all, it would just be an attribute in the CaseStatus lookup table.

Seems like sometimes ya can't see the forest from the trees.

David