3 Replies Latest reply on Mar 17, 2010 12:08 PM by philmodjunk

    Checkbox Sets



      Checkbox Sets


      I have a Checkbox Set that has 25 check boxs values, it was working well, but i had to change around the order and add a few things. Now when i search via the Find + (a checked value) i get things that aren't checked, as if its holding the value still. Is there away to get remove these ghost checks. If there is a better way to search the check box im open for that to. I thank you for any help you can give. 

        • 1. Re: Checkbox Sets

          Changing your check box field's value list values, does not change the data already stored in the field.


          It sounds like your field may be storing values that no longer match an item in your current value list. If that's the case, the data is still there, but the check box formatting hides these values from view. To check for this, place a copy of your check box field on your layout next to the original copy and set it up as an edit box. Now inspect the contents of this field for data that doesn't match your current value list.


          If you need to update this field for large numbers of records in order to correct the problem, make a back up copy of your file and try out the Replace Field Contents tool in the Records menu.

          • 2. Re: Checkbox Sets

            How do you set it up as an edit box. Im super new to this, and as a intern for this company this is the sweetness that i get to deal with. 

            • 3. Re: Checkbox Sets

              An edit box is the simple unformatted field.


              Enter layout mode.

              Simply copy and paste the existing field or duplicate it.

              If using filemaker 10 or older, use field / Control | Setup... to change the copied field's format from "Check boxes" to "Edit Box".

              IF using FIlemaker 11, this option is found in the inspector.


              After doing this, you may want to "play" with the fields by clicking check boxes and noting how the data in the unformatted copy changes--that can be instructive.