Cascade Update Trigger Problems

From: <dleenhouts_at_gmail.com>
Date: 7 Aug 2006 11:18:48 -0700
Message-ID: <1154974728.247035.145200@m73g2000cwd.googlegroups.com>

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 - 13:18:48 CDT