I have an interesting issue - I have a table called 'employees' which has EMPID set as a primary key I have another table called 'qualified_master' which has EMPID as a foreign key that references 'employees'
Well, since mistakes happen, an employee was entered with the wrong EMPID in both the 'employees' table, and also had entries entered into the 'qualified_master' and 'qualified_details' tables. 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. Thanks! Charles Sikora Coordinator, Gas Storage Manlove Field Peoples Energy Corporation ================================================ 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/
