>I have been keeping my financial records in Ebase and my mailing addresses,
>which require constant upkeep in another office (volunteer) in a database
>they use. I would now like to merge the two lists and keep everything in
>Ebase. Is there a way I can merge the two databases and not manually input
>all of the information again (time and prone to errors)?
>
Just to be sure I understand...
You have donation records in ebase which do not have address and
contact info, or at least the contact info is outdated. Contact info
for those same people is in another files.
To be able to update addresses reliably you'll need to establish some
kind of unique relationship between records in the two files. This is
the function of the key field in a relational database. I can't think
of an easy and reliable way to establish that relationship. I suppose
you could assign record numbers in one file, and manually enter the
record number in the other file, which would be easier than
keyboarding the addresses.
Once you have this relationship, you could use the calculated replace
function in FileMaker, or import/update records, to copy the address
info into ebase.
If your address file is new people, that is, folks for whom you don't
already have a record in ebase, you can just import them with the
ebase import routine.
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
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
---------------------------------------------------------------------
