>I am importing an NCOA update to existing records. Is there a clever >trick to add new notes to the memo field without deleting existing memo? >Thanks, Jennifer >
You'll need to build a relationship between the names file and your NCOA file based on the Record ID. Then you can use the Replace command (Calculated) to replace the value of the memo field with [Memo field in names] & [NCOA relationship::related memo field in the NCOA file] you can fill in the details between the brackets, but the idea is that you calculate a new value of the memo field which is the current value of the memo field plus whatever you want to add. Back up your file set before you do this. The calculated replace command is dynamite and it's easy to make a serious mistake. -- -- 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 ---------------------------------------------------------------------
