Letter3 code is in use and presumably contains records you don't want to delete anyway. It stays. Letter1, which has a unique description though the same code, needs to have it's records deleted or modified to reflect a new code with a new set of code values. If there's a way to "find" the contact, payment, action, note and other records with the offending Letter1 code (you can probably find them by searching on the code description if it's available, otherwise via the code and a unique add date or add time) you could create a new code for Letter1 (and a new description, something slightly different than the old Letter1 description so you can find it) and then find all the offending records and do a FMP replace on the source code field, choosing the new code.
For example, create the new code for Letter1, then go into the Contacts file (Contacts Tab->View Contacts) and then query for the records with the Letter1 code attached (either in the source code field, which should list the two codes with the different descriptions or in the code description field which will require re-setting the field format to allow entry). Select the new code in the source code field and do an FMP replace on that field. You'll need to do this in any file where the code has been used. Then you can delete the offending code and you're back in business.
Carl
Rachel Walden wrote:
--Okay, I managed to delete the errant contact records. Upon trying to add the correct ones, I discovered that two differently described source codes had ended up with the same code, which I didn't know was possible. We'll call one Letter1 and one Letter3. I cannot delete the Letter3 because it says it is in use. There are records that need to keep the Letter1 contact record. How can I resolve this???
Carl Paulsen
8 Hamilton St.
Dover, NH 03820
603-749-2310
[EMAIL PROTECTED]
------------------ Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
