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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top