Perform Find using CheckBoxes

[miszczykr]

What is the best way to perform find using a checkbox? Let's say you have a field Location with values City A, City B and City C. I want to give a user opportunity to click on a checkbox (ex chosing City A and City B will list all records with City A OR City B in field Location.

I know checking multiple checkbox means typing Locations with new line sign. Is the only way to achieve that sripting it by cutting lines and for each line performing New Record/Request command? Is there any easier way?

[BobWeaver]

You can create a self join from a global checkbox field (containing the list of locations) to the location field. The user clicks on the desired citys, and then your script performs a Go to Related Record [show only related], and voila!

[Ugo DI LUCA]

Bob Said

and voila!

You can only see his right eye, but can you see how it is shining

Change your find method from a classic find to a relationship. Checkboxes are really the best way to achieve this as

separating record with a Carriage return will create a new index for any "

[miszczykr]

I am not sure if it is still going to worl for me. Actually I have more checkboxes on my find layout. Next to Location there is a Device Type and Make. What I did by now was using a classic Find concept with some scripting. Before I perform Find I cut each line of "multilined" checkbox field using Middleword function and then New Record/Request for each line:

SetField (GField, Field)

SetField (gCountWords, WordCount(gField)

SetField (gCounter, 0)

if (WordCount > 0)

Loop

Set Field (gCounter, gCounter + 1)

Set Field (Field, MiddleWords (gField, gCounter, 1) )

Exit Loop if (gCounter >= gCountWords)

New Record/Request

End Loop

End If

I stopped for a while, because now I have to deal with next checkbox field and it's pretty annoying, because next Find will have to search only subgroup of previously found records.

I am not sure about your tip with self joint relationship. I need to perform Find to choose some records and generate a report for them. When I defined a relation between my Location field and a global field with the same checkbox value list, going to related record moves me to first record with given criteria. In my case I need a list of all of them - not just first one. I think I am missing something here, but as you know my needs, I am pretty sure you are going to help me soon.

[Ugo DI LUCA]

Hey,

Why not just concanate Device, Type and Make and just use another concanate calc for the right part of your relationship. Or just have a look at this post for a Filtering portal that could match what you're trying to do.

Not the best, but could get you started