Cascade Update Trigger Problems
Date: 7 Aug 2006 11:18:48 -0700
[Quoted] [Quoted] Does anyone know how to use a trigger to update a table (& all child tables) so that an existing pk is updated to another existing pk. For instance, merging records so that:
Key CompanyName 1 GE 2 General Electric 3 general electric 4 G.E.
All become one single record. I would even be satisfied by assigning all 4 of these into a 5th record as long as all related records are attached. These also have a number of child records associated with them as well (orders, employees, etc).
Thanks Received on Mon Aug 07 2006 - 20:18:48 CEST