All,

I hope this is in the right forum. I've found topics in this forum that were similar, but not close enough to give me my answer.

I have created a value list that displays as checkboxes. (Is my terminology correct?) The value list contains the different categories I want to group my records by. For this purpose let's say that there are 4 values in the list -- male, female, married and unmarried. If the record was mine I would check off male and married. (The fact that my example values can be mutually exclusive is simply a coincedence and not a part of my problem.)

I want to be able to create layouts that show all the records that have one of those values selected. To continue with my example, I would have 4 layouts -- one for each of the values.

I'm able to do manual finds by clicking on the find button and selecting the appropriate value. I'm not able to create a script that let's me find records based on the checkbox value.

Two questions

1. Is there a way to write the script so that this will work?

2. If not, should I use something other than checkboxes? I was thinking of having radio buttons. In this case my value list would simply be yes/no. I would then have 4 fields -- male, married, etc. Each field would have the yes/no value list. Is this better?

Thanks

Christopher

For the purposes of a scripted Find, you can ignore the presence of value lists attached to any fields. Just use a Set Field while in Find Mode to set the Find criteria, like this:

Enter Find Mode []

Set Field [ field ; "criteria" ]

Perform Find []

The fact that my example values can be mutually exclusive is simply a coincedence and not a part of my problem.

You should account for this by using separate fields for different attributes and radio buttons to help maintain the mutual exclusive entries. In your example, you should be using a Gender field and a Marital Status field, each with radio buttons for their values.

A Find for records with something in either field would look like this:

Enter Find Mode []

Set Field [ Gender ; "*" ]

New Record/Request

Set Field [ Marital Status ; "*" ]

Perform Find []

I'm going to have to give this a try.

In the first solution, where you have "criteria" I'd put "male" or "female"

correct?

Christopher