"Elainie" <Elaine.Macintyre@bsc.wales.nhs.ukwrote in message
news:1153141938.600102.127560@b28g2000cwb.googlegr oups.com...
Quote:
>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 
