I was wondering if anyone has ever run into this. I have just started as Donor Relations Coordinator at a regional hospital, and found that many of our queries were run poorly because we lacked standardized constituency codes.  The strange thing is, as I'm trying to create new codes, but mostly delete old codes that were never used, Raiser's Edge does not allow me to delete these codes from the Config Table.  Even after I've run a query for the code and ensured that it is not assigned to any constituent records, Raiser's Edge gives me the message "This table entry cannot be deleted because it is in use by one ore more records in the program."  Anybody run into this, or have any advice?

Constituent codes are also used on the Miscellaneous tab for gift records.  I would suggest you query that field to find them, change the codes as needed, and then you should be able to delete the code from the table.

 Shirley

As stated they are also on the gift record.  You can globally change the gift record by replacing the constituency code with a "blank" field.

 Thanks so much!