thank you - it work perfectly J
At 12:58 PM 12/21/2004, you wrote:
> I have situation where I have a primary and foreign keys - an error was > made and the wrong information was entered in both tables - Is there a > simple way to correct the information without removing the foreign key?
Try
ALTER TABLE PrimaryKeyTable ADD CASCADE
and then update the value in the Primary Key table. It should cascade the changes to ALL foreign keys referencing that table that contain the changed value. -- Larry
