Your question is a little confusing to me. You can use the Update Trigger of a table to post updates to a different table. What you can not do is use an update trigger to post a data change to the table [i.e., the record] being updated.
>Is there a way, using an update trigger, to effect changes to a different table when a value in another table is changed?
>
>For example:
>
>Parent Table/Field: CLIENT.acctbal
>
>Child Table/Field: TRANSACT.amount
>
>
>Is there a way to edit an existing record in the TRANSACT table, and reflect the change in the CLIENT table? I don't see how to know what the original value was before the Update Trigger was called.
>
>Thanks for any insight,
>Chris
Mark McCasland
Midlothian, TX USA