How to indicate that a user has already seen a record

[Guest]

I have created a database showing the jobs we have workin. What I would like
to be able to do would be to indicate for the user which jobs they have
already reviewed and which have changed since their last viewing.
Essentially, I want to add a feature similar to a user forum where when you
log in you can see which postings are new since yur last visit and which have
changed since your last visit. Can anybody give me an idea of how that might
be accomplished? The database we work from has been split and is built in
Access 2003. As always, thanks for any suggestions.

 

[Pieter Wijnen]

Thinking on the fly here.

Create a log table in the front end.
in the Current event of the Form:
Compare the Record (ID) to the Log table (Trigger Bold or whatever)
Add any viewed record to the log table as needed

HTH

Pieter

 

[Guest]

Thanks Pieter. Strangely enough, I was thinking along the same lines. Guess
I'm getting good at this Access stuff! As if!

Thanks again.