General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update Trigger Question
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only