This problem will also occur if you change the value list. If you checked off some choices in the EMAIL LISTS field in some data records, then removed those choices from the value list, those choices still are hidden in the email list field, even though you can't see any check-marks for them. You get the Filemaker warning because it sees values in the field that aren't currently in the value list.
One solution is to change the field style to STANDARD. Anything value that was checked will show up as a list of values. Do a FIND on the values that were removed from the value list. If you don't know which values were removed, do a FIND on the field being 'not blank' and scroll around and look for the missing values. If it's a small amount of records, you can fix them one by one. If it's a ton of records, you can fix them with complicated REPLACE commands. Be careful! A REPLACE command in a checkbox field can remove all the data, not just one value. ------------------------------------------------------------ Bob LeLievre LeLievre Information Services List Management Services for Non-Profits voice: 617-474-9131 email: [EMAIL PROTECTED] website: www.lelievre.net -----Original Message----- From: Dave Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 7:20 PM To: TechRocks Support Subject: [support] Re: "Email Lists" field >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 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? The field "Email Lists" has a validation criterion in its definition. It is required to have only values that appear in the value list "listservs list". It appears to me that you are attempting to add a value that is not on that list. Since you assert that you are selecting a value by using a checkbox, I wonder if the value list assigned to this field is not the same one that is requred in the field definition. In layout mode, select the field and then the menu item Format>Field Format. It should say that the field is formatted in check boxes and give the name of the value list assigned. This should be "listservs list". If it is not, change the list assigned either to the field format or the field definition so they match. -- -- 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 --------------------------------------------------------------------- ------------------ 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 ---------------------------------------------------------------------
