Matt: Yes, that can be handled in my design. Although as I mentioned, I'm going to have to do some serious testing in order to determine if this is even possible..

MMartin1: in fact, I was using the incorrect terminology (again): I should have said "candidate key". I've been burned once by natural keys, when Newfoundland (NF) renamed itself to Newfoundland and Labrador (NL).