Another round of the old "To save dead officers or not to save, that is the question" pendulum:
When an officer dies, keep him in a "morgue" for one 5-day cycle. While in the morgue (or while alive) an officer can be selected for a "Hall of Fame" by clicking a checkbox. The hall of fame is a completely different table with a listing of name, final rank, stats (and maybe even history), so that we don't run into the problem of dead officers messing up filtered searches that we used to have IIRC. BTW, can one put notes in an officer, e.g. "Was in command for 1st Battle of Orion, defeated major T'Grunk fleet"? If so, those should be saved too....
John