Two possible solutions. First turn rules temporarily off and try. Second, backup data for both tables for the employee in question, delete data from tables, edit backup file with new employee ID, reload.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 18, 2002 1:46 PM To: [EMAIL PROTECTED] Subject: Constraints 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/ ================================================ 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/
