Checkbox List Records

[Curse]

I have a checkbox list that I need to display all the fields that are checked. Also if its possible for it to omit with the State selected.

Ive tried a bunch of different things and read lots of tutorials but cant find anything! can anyone help or point me in the right direction please.

Edited December 6, 2007 by Guest

[Fenton]

You need to give more details. Because the statement "I have a checkbox list that I need to display all the fields that are checked." is too vague. A checkbox is a view of a value list; it could have only 1 value (like 1), or it could have many values. On the layout each instance of a field can only have 1 checkbox attached.

You could mean, "I want to see only the values which are checked for one field." In which case just put the field on a layout, but not formatted as a checkbox. You will see the multiple lines of values.

If you mean, "I've got multiple fields, but I only want to see the ones that are checked." Well, that's a lot more trouble.

It is important to distinguish between "field" and "value in a field."

[Curse]

Thank you so much for responding! and forgive me, I'm new at this program. I will try to explain this as best I can.

I am making a database that lists every type of category (in check box form) in the motion graphic industry (such as print, web, photography, animation, advertising, etc..) Depending on what category the user chooses, I want the search to show the companies that match the categories chosen.

The information in the body doesn't match up when you click a check box. It actually doesn't work at all. Is that because I only made one check box for all of them? Do I have to make individual check boxes for each one? Any help you can provide is greatly appreciated. Thank you for your time!!

[Fenton]

Well, what you've got looks like 1 field. The Value List you're using has the values, "Print," "Web", etc., each separated by a carriage return (on its own line). It must be a Custom type of value list, as they are not alphabetical.

So, if someone checked [x] Web and [x] Animation, then those 2 values would go into the field; also separated by carriage returns (but you can't see that, you just see them as [x] next to the value).

If you went into Find mode, checked [x] Web and [x] Animation, then hit the Enter (or Return) key, then you should Find this record; and any others that had BOTH "Web" AND "Animation" as the beginning of words on any line (something like that).

Upon looking at your screenshot, I can see why it's not working as you expect. You've put the field in the Header part. If you want to use this field to assign categories, then you'll need to put it into the Body part, along with the other fields.

There is a clever use of such a checkbox field in the Header. But it would not be a regular field in that case. It would be a global field (text field with global storage to be precise). And you would still need the regular Categories checkbox field in the body (this could be on a Form view layout, List views are not great places for big checkbox value lists).

I think that's how I'd do it. The big checkbox for the regular field on a Form view layout, to assign the categories. Then a global field using the same checkbox value list in the Header on a List view layout.* You would then likely use "Go To Related Record" step, using a Relationship, not a Find. You'd need a button to do this, after checking the values you wanted to find.

Go To Related Record works very well with multiple-line fields (or multiple records). It performs an exact "Or" find. It would find any record that had EITHER "Web" (exactly) OR "Animation" (exactly). Which is likely what you're trying to do.

Or you can include the checked values in a Find. But that requires a scripted Find. It would be best if you described precisely what it is you want to find. And also uploaded either your sample file, or just a "clone" of you file, if it is large. File, Save as Clone creates an empty file.

Use the Preview button first, instead of "Add Post." Then use the Manage Files button to find and add your zipped file.

*The Categories field could also be in the List view (Body part). But not formatted as a checkbox value list. It would just be a regular text field, as tall as you need to show the maximum number of values expected in the field. It would look like (in the case I mentioned):

Web

Animation