Holly Ross wrote: > > 4. Add and Delete values as needed (BE CAREFUL ABOUT DELETING - IF YOU > DELETE A VALUE THAT HAS BEEN USED, THAT DATA WILL BE LOST FOREVER)
Good warning, but it isn't entirely true. Value lists merely store data in text strings (i.e. words) so that when you check an item in a check box formatted field (or select an option from a popup menu field), filemaker places that text string in that field. When you delete a value from a value list, that data (the text string) remains in the field. It isn't deleted, but it is often hidden. What happens is you can no longer search for that value in the usual way. You could still search for that text string and find it, but that doesn't work with checkbox formatted fields (such as the affiliations and email lists). With these fields, that record won't have the checkbox marked (after all, that checkbox no longer exists) but it will still have the text string. Thus, if you were to re-add the value to the value list, voilla, the box is checked. With popup formatted fields, the text remains in the field box but you obviously can't search for that value using the popup list. Try this all out. It's a good thing to remember. Carl -- Carl Paulsen New Hampshire Rivers Council 54 Portsmouth Street Concord, NH 03301 603-228-6472 603-228-0423 Fax [EMAIL PROTECTED] ------------------ 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 ---------------------------------------------------------------------
