SQL:Recursive Relationships

ONLINE 7.10 UC2 If you create a trigger to manipulate parent/child relationship on the follow table, you get an error ================================================================= -747 Table or column matches object referenced in triggering statement. This error is returned when a triggered SQL statement acts on the triggering table, or when both statements are updates and the column being updated in the triggered action is the same as the column being updated by the triggering statement. ================================================================= company-id parent-company-id ---------- ----------------- GM NULL CHEVY GM SATURN CHEVY PONTIAC GM FORD NULL Is there a workaround other than creating two separate entities? Is there a way to create self referentil integrity constraints? Thanks -- ahmed.khafagy@washingtondc.attgis.com