>Hi there, we are running ebase v 1.02 on a win 98 platform. We have the >"Email Lists" field set as checkboxes, pulling values from a defined value >list. We are encountering an unexpected warning box when editing the values >in this field. When adding a check to a record that didn't have one before, >nothing happens and you go about your merry way. However, when editing >(removing the check from that box) a >record that does have one or more boxes checked, a dialogue box pops up with >the following text "This field is defined to contain only specific values. >Allow value?" with three options - "revert field", "yes" or "no". > >In trying to figure it out, it appears to me that ebase (or Filemaker) is >just verifying that you really want to make a change to those checkboxes. If >you choose yes, the value changes and is reflected correctly in a search. Is >this so or is it something more complex than this?
It's a little more complex. This field is defined with a validation criterion, that data must be a member of the value list "Listservs List". - that is, FileMaker warns you when a value is entered that does not appear on the list. My guess is that you have deleted entries from the value list. Deleting values from the list doesn't affect current data - it just changes the values presented as option. You probably have records which have values in that field which have been deleted from the value list, and whenever you try to modify that field in records with deleted values, Filemaker warns you that the old values are there. You can look at the index for that field by selecting that field and striking Cmd (Ctrl on Windows) - I. This will show you all the values in this field in all records. This should match the value list. -- -- 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 ---------------------------------------------------------------------
