By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

AUdit trail

P: n/a
I have two tables, Placement Details and Placement History. I have 2
forms, Placement Details and Placement History. 5 fields from the
placement details fields need to update fields in the placement history
fields.

name
placement
funding
effectivedate
authdate

I need to do an audit trail of these fields for future use. When an
old person leaves a nursing home then the placement history must stay
the same as the old placement but they enter the new placement in the
placement details form. Therefore building up a history of when that
person moves homes.

Please help - tried the update expression but it does not appear to be
working

Elaine

Jul 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Elainie" <El**************@bsc.wales.nhs.ukwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
>I have two tables, Placement Details and Placement History. I have 2
forms, Placement Details and Placement History. 5 fields from the
placement details fields need to update fields in the placement history
fields.

name
placement
funding
effectivedate
authdate

I need to do an audit trail of these fields for future use. When an
old person leaves a nursing home then the placement history must stay
the same as the old placement but they enter the new placement in the
placement details form. Therefore building up a history of when that
person moves homes.

Please help - tried the update expression but it does not appear to be
working
Hi Elaine.

It looks to me like you need to establish a one-to-many relationship between
your tables - for every one placement you can have many "history" details,
so have your placement details in the "one" table and the fields you listed
above in the "many" history table.

HTH - Keith.
www.keithwilby.com
Jul 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.