Logging History

[Katiemay]

Hey folks,

I am trying to set up a system in my database that allows me to log every time a patient's info changes (the current program they are enrolled in, when their counselor makes notes, when they've been contacted etc). Theoretically, what would be the best way to go about doing this?

My setup is basically this: I've got one table with patient info. Names, addresses, contact info etc. I have another table set up for each program they can be enrolled in, with that programs specific information. I believe I need a third table for notes only, linked to the patient by patient ID. I want to be able to view a form that lists dates and times as to when changes were made, and which changes were made. If there's a better way to go about it, any help is appreciated.

If I need to be more specific, please let me know. (By the way, I suck at code, so something mildly simple would be a plus, but not entirely necessary.)

Thanks in advance!

[June7]

Here is one approach http://allenbrowne.com/AppAudit.html

Search the forum on keyword: audit

Start with:
https://www.accessforums.net/program...ros-31071.html

[Katiemay]

I'll have a look through this, thanks for the info!