Charles, Add the employee again, with the correct ID. Then change the FK table ID to the correct ID. Then delete the PK row with the wrong EMPID.
Bill On Fri, 18 Oct 2002 13:46:13 -0500, [EMAIL PROTECTED] wrote: >Because of the constraint, I cannot update the EMPID in either table! Is >there a way to change it I am not seeing, short of deleting the rows in the >'qualified_master' and 'qualified_detail' tables? That is my last resort >because there is a lot of data in those tables tied to this particular >employee. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
