Thanks;
I see that the child records could be a problem as it was because of a child
record (trying to print a thank you note) that the problem came to may
attention.
But I think it'll be okay. There was only the one record involved that had
a payment (the one I'd tried to print a thank you note for)
So I deleted that one and knew I'd have to reenter it entirely.
The other 13 dupes were one set of organizations and one set of Congressmen.
Neither had any payment records. I'm just grateful that I had tried to put
in that new member and print his note when I did. I mean, that I'd become
aware of it at only 13 records. And as they were all 26 keyed in the last
6 months, there were no contact records for either set yet.
Thanks! It all looks okay now.
Lisa
-----Original Message-----
From: Bogue, Gary [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 8:35 AM
To: TechRocks Support
Subject: [support] RE: double record numbers
Lisa,
A Warning - Be careful deleting records with duplicate record numbers. Since
FileMaker doesn't know the difference between the two Name records, as you
have already noticed, it will happily delete any and all related records
which are set up for automatic deletion with the parent record. This applies
to *either* of the duplicated records.
So let's say you have a legitimate record for Ms. A with 2 dues payments and
a large contribution. Then you add Mr. B, with the auto-numbering mistakenly
assigning it the same number. Now Mr. B also appears to have made the same
payments, even though he really just bought a bumper sticker. When you
delete Mr. B's record in the Names file, it may also blow away Ms. A's
payments, since they are linked by the same Record Number. I'd suggest you
check. It may be necessary to re-enter all the payments (and any other
details) for the original record after deleting the dupe.
There are sometimes easier ways of handling this if you know about the child
records before deleting. In this case, the ebase programmers seem to have
done such a great job of enforcing the integrity of the Record Numbers that
adding back related records appears to be the easiest way. Dave, have I
missed some clever workaround?
Gary Bogue
> Subject: RE: double record numbers
> From: "Roland and Lisa Morris" <[EMAIL PROTECTED]>
> Date: Sun, 4 Feb 2001 22:00:35 -0700
> X-Message-Number: 1
>
> Thanks Dave,
>
> That was exactly the problem and I have it all fixed now.
>
> Now just to clarify; I don't see an export function in the ebase program.
> A function for sending all or part of the names and addresses to someone
> else for use in a mailing.
>
> So although I am not to use the Filemaker IMPORT function on the drop down
> menu, I still need to use the associated EXPORT function to send stuff
> out,
> right ?
>
> Thanks,
> Lisa
>
> -----Original Message-----
> From: Dave Shaw [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 03, 2001 10:45 AM
> To: TechRocks Support
> Subject: [support] Re: double record numbers
>
>
> Record numbers are auto-entered when a new record is created. The
> next number to be used is set in the field definition and updated if
> you add a new record, BUT when you import records you need to re-set
> this index to a record number higher than the largest in your import
> set. If you use the ebase import routine, this gets done for you.
> Apparently you used the FileMaker menu item to import.
>
> So, delete the records with duplicate numbers. Find the highest
> record number (by sorting the records by record number, for example).
> Go to the field definition for Record Number and check the Auto-Enter
> tab. You'll see that it's checked to auto-enter, increment one. You
> should set the Next Number to one higher than the highest record
> number in your file.
>
> Now when you enter new records, the will be numbered higher than the
> ones already in your file.
>
>
------------------
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
