Messed up Searches

[CYFC]

I have a field with 7 checkboxes. When I do a search for one of the check boxes, some records come up that don't have that checkbox checked. What's the deal???

[Raybaudi]

Hi

which are the values of those check boxes ?

[Ender]

If the box you checked is a substring of the other values, it can find those too. If this is not what you want, change your values so that no substrings are in there.

Also check the field's values for old values that aren't in the checkbox set anymore. For example, if you once had "Mark II Widget" as a value in the value list and changed it to "Widget", records that had the old value checked would still have that value in the field, you just wouldn't see it as a checkbox anymore. You have to search the field manually (without the checkbox attached) to update the old values. Maybe use a Replace or a Find/Replace to clear or update the old values.

[CYFC]

The values are the RSVP status' from an event.

4/24 Registered

4/24 Wait List

4/24 Reg. Confirmed

Attended 10/6/06

10/6 RSVPd

4/24 Staff (no facilitators)

4/24 Attended

When I click the: 4/24 Attended, that's when I get some records with that not checked.

These values do not appear in any other value list.

Edited June 25, 2007 by Guest

[Ender]

And if you take the value list off the field, what's in the field?

[CYFC]

This field only contains those values. Once they are taken out, it says: no values defined (if I keep the field as a checkbox field).

[Ender]

If the field format is defined to display as an "Edit Box", and you've checked all the lines in there, the next thing I'd ask is whether the field is (or ever was) a repeating field? Hidden repetitions with old data can also cause a record to match in a Find.

[Raybaudi]

The values are the RSVP status' from an event.

Did you create a custom Value List of those seven items ?

[CYFC]

It was never an edit box. It was created to be a checkbox.

Those 7 seven items are custom values.

[comment]

I think it would be best if you posted a small file demonstrating the problem.

[Raybaudi]

Is that field a "text" field ?

( and NOT a "number" field )

[Ender]

It was never an edit box. It was created to be a checkbox.

As I said above, if your checkbox values change, existing values in the records are not changed automatically.

The purpose of viewing the field without the checkbox set attached is to see the actual values in the field, instead of only the current checkbox choices which may or may not reflect the actual data in the field.

[CYFC]

-Does that mean that I should view it as an edit box? I guess I'm not sure how to view just the field...

-It's text not numbers...

[AudioFreak]

Ender is asking that you make a duplicate of the same field in layout mode and change it to a Edit box so you can view the data in the field.

[CYFC]

Ok Thanks. Yes, I did do that. I do see that there are some values that are not currently in my checkbox value list. However, I do not see any correlation between those extra values and that value that is popping up when not clicked...

[Ender]

Maybe you can share what the values in the field are and what you actually searched for.

[CYFC]

OK, my value list for this checkbox field are:

4/24 Registered

4/24 Wait List

4/24 Reg. Confirmed

Attended 10/6/06

10/6 RSVPd

4/24 Staff (no facilitators)

4/24 Attended

When I look at the values in the edit box, I have those plus:

RSVPd

RSVP'd

When I click on 4/24 Attended in the checkbox (or type it in the edit box), there are 10 or so records that show up that do not say 4/24 Attended or have it checked.

[CYFC]

Might this have something to do with the fact that the word "attended" is another word in the value list, as well as "4/24"? I added a field called "10/6 Attended" and did a find. Over 200 records showed up, none with 10/6 Attended checked. But "10/6" is already part of a value as well as "Attended". So, am I onto something?