I'm working with ebase.102 to update the Action Preference value list based
on a separate excel file with these "action preferences" checked. Here's
what we did:
1. �Created the appropriate values in the action preference value list to
correspond with our import file
2. �Imported the preferences into User Field 1-10 (e.g. Write Letters =
User Field 2)
Now we'd like to find all records with an "X" in User Field 2 and update
their action preferences to note this updated value. We're having a problem
because updating a value list using Filemaker's Replace All command will
duplicate the other values in this list for each record, not just the one
value. Therefore, if Mary has "Write Letters" and "Volunteer" checked when
I use her record to update the others, everyone will then have ONLY "Write
Letters" and "Volunteer" checked, removing other previously checked
options.
I understand that this is because Value Lists are one field, and the FM
replace feature updates an entire field; however, I'm hoping someone else
has found a way around this problem. I see that ebase has an "Import VOL:
Action Preference" field, how can I use this? Any advice?
Thanks!
Tompkins Spann
Technology Field Manager, NARAL
202-973-3065 office
202-421-8678 cell
[EMAIL PROTECTED]
http://www.naral.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
---------------------------------------------------------------------
