This can be done, but it's not a a primary key.
Primary keys uniquely identify records in the table in which they are defined. Only one record would be assigned any one primary key value and that value, once assigned, should never be changed.
Can you explain the purpose of the KeyNum field and how each of the 5 Acct... fields differ from each other?
OK, so let me step back I apologize. In our old system we had a budget db. it held 5 different types of records Base Pay, Stipends 1 and 2, Longevity, and Insurance. All of which, as I can tell, need to be in the same table due to reporting requirements. We distinguished them using the keynum field... So I just answered my own question...I'm doing it all wrong! LOL!
Sorry everyone! I use to bounce all of this stuff off my old boss Mac McCassey, but he has now retired, so I have no one to bounce the ideas off of anymore. I apologize in advanced there will be more of these.
Thanks Phil and everyone.
Butterfield Technologies, LLC
This would be a pretty good place to bounce ideas and there's no reason why you can't use this calculation field to match to specific groups of records, just don't used as a primary key.