Audit trail

E

Elainie

I am attempting to do an audit trail of Nursing homes. I have a
patient who is in one nursing home, then they move to another nursing
home. How can I do a history on a form for this. I have crated a
subform, so that when you enter a nursing home it will enter it on the
subform, but how do I get it to save the last nursing home therefore
building up an audit trail.
 
B

Barry Gilbert

Instead of changing the value of their current nursing home in the patient
table, I would suggest creating a seperate table for nursing home history.
This table would have a foreign key to the patient's record. It would also
have a move date. This will allow you to retain every move the patient made.
If you usually only wanted to see the nursing home that they're currently in,
you could use the maximum from the date column.

HTH,
Barry
 
Top