Audit trail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elainie - 13 Jul 2006 14:51 GMT

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.

Reply to this Message

Barry Gilbert - 13 Jul 2006 15:22 GMT

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

> 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.

Reply to this Message