You can put code in the AfterUpdate event of the Graduation Date field that
automatically fills in the Status field when you enter the Graduation Date.

Steve



"Brad Hodges" wrote in message
...
I am an administrator over military courses. I'm trying to slim down an
overly redundant database. I would like to make it as dynamic as
possible.
I have two records in the same table; Graduation date and status.
Can I have a graduation date automatically another field called status
which
currently is either "active" or "history" without using a manual "update
query" process? I would assuse it's a simple select statement in the
status
field but need help.