AUdit trail
Question posted by: Elainie
(Guest)
on
July 17th, 2006 02:05 PM
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
1
Answer Posted
"Elainie" <Elaine.Macintyre@bsc.wales.nhs.ukwrote in message
news:1153141938.600102.127560@b28g2000cwb.googlegr oups.com...
Quote:
Originally Posted by
>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
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 197,028 network members.
Top Community Contributors
|
