>I'm planning on adding a second set of address fields for businesses >and using the Record Type field to choose which address set to use, >as it does for business\org names. Any hints, considerations, or >ideas on how to do this? Thanks, Jannah Riemer Data Manager >Cornucopoia Community Advocates Sedona, AZ I have done that for a client, and they seem pretty happy with it. Here's how I worked it. Backup your file set first, of course. I made two new sets of address fields, homeaddr, homecity, etc., and workaddr, workcity, etc. Copied the data from the existing address fields to the appropriate set of fields with a series of calculated replace steps. Do it in two stages, one for those records for which you have a home address, next for the work addresses. Add a flag field which you will use to specify which address to use in the mailing addresses. I recommend adding a field, since you might have an Individual record for which you want to address mail to an office address. Change the field definitions of the existing set of address fields from text to calculations of the form: If the flag is "work" use the work address; else use the home address. This scheme has the advantage that all the downstream address calculations used in the labels, envelopes, etc., still work, since the address you want to use for mailing appears in the same fields they used to before you waved your magic wand. One caution that cropped up recently. The standard import scripts won't work any more, since they rely on an embedded import order which moves data into the address fields. Since they are now calculations, that won't work. You can fix that by changing the import order embedded in the script 151 - Import from Import 1. I remember this process taking several hours of my time, and several more of the client's. It's not easy and by no means simple. -- Dave Shaw Northwest Classics, Inc 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 ---------------------------------------------------------------------
