Advice for Audit log

O

Opal

I am looking at Allen Browne's audit log at:

http://allenbrowne.com/AppAudit.html

and wanted some advice to ensure this is
the right way for me to go to solve my dilemma.

I need to be able to run a query to show results
if a new record has been added to a table.

I want to be able to give the user the functionality
to email a report to another user if a new record
has been added to the table specific to
the second users area of reponsibility.

I wanted to do this automatically. So user (1)
has added a record and specified a specific user
area (2) for responsibility to action. As soon as the
record is added (or edited) to show user (2) is responsible
I want an email to be generated to user (2) to let him
know he has something awaiting his attention. I have
the email function working to send the report, I just
need to know how to fashion the query to support
this. Thank you.
 
Top