I am wondering if there is a way to write an expression
that would cause the most recent update to be plugged into
one of the fields on my form/table.  I have a Client table
that includes demographic data and other types of
information about each participant that we see.  I also
have another table (Supervision Level) table that records
Supervision Level for each client (a client may go through
several levels of supervision before completing the
program).  I would like the Supervision Level on the
Client table to be filled with the most recent supervision
level from the Supervision Level table.  Basically, if the
client moved from a Level 3 to a Level 4, I would like the
Client table to indicate that the client is on level 4.  
This is important because several reports are grouped
based on the level of supervision. A few weeks ago, a
couple of individuals gave me some advice about this thing
regarding DMAX and MAX, but I must have missed something
as I attempted to work through it.  Any help is greatly
appreciated.
Thanks,
Sheri