Charles - First, you'll have to add a new Employee record with the correct EmpID number. Then it will allow you to change the number in the foreign tables. After they are all changed, you can delete the original record in the Employees table.
Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 http://www.softwaremgmt.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 1:46 PM 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/
