>A caveat. Check the archives for a solution to the FMP replace problem, >the only drawback of the checkboxes. I routinely do replaces on >checkbox fields with a calculation that works.
There are at least two operational challenges to using check boxes. One is, as Carl mentioned, assigning a value to a bunch of records using the replace command. If you simply replace the value in the found set, it overwrites the values with the value in the current record. What you need to to is to ADD the value you want to the values in the found set with a calculated replace using Field & "<cr>" & "new value" Where Field is the field you're working on, <cr> is the FileMaker paragraph mark, and "new value" is what you're adding. The second is searching. If you have values of, for example "Board Member" and "Former Board Member", both will show up in searches for "Board Member". Best way around that is to leave no spaces in the values, i.e., BoardMember and FormerBoardMember. -- -- 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 ---------------------------------------------------------------------
