I have an application where I'm not deleting
records from a table, just terminating them
by putting a value in TermDate (for archival
purposes). This obviously causes problems
if the same record is added again at some
future point.

The primary is a compound key.
I thought that filtering the key on
TermDate = {//}
might work, but if it did I wouldn't be
writing now :-)

Is there a standard way of handling this
outside of changing out key fields?