>What is a better way of handling this situation: >I have a need to accomodate a single record having multiple values >in a single field. > >For example, an organization XYZ might have multiple entries under >"type". It might be a "foundation", a "donor", a "member", etc. I >might want to do a search the field "type" for any of those values >and be sure that I would find XYZ for any of them. >
In your example, searching the field for any of those values will include XYZ in the found set. I presume you have the field Type formatted as a check box, and several of the boxes might be checked. Go to find mode, check the box for foundation, and XYZ will show up. Do the same for member, and XYZ will be included. One caution... FileMaker includes a record in the found set if it includes any of the words in the search criteria. So, for example, suppose you have a field with values Board Member, Former Board Member, and Member. If you search for Member, any record with any of the three possible values will be included. The best way around that is to make each value a single word, as BoardMember, 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 ---------------------------------------------------------------------
