Nope. You've hit on THE way.
You need the two requests to create the "or" condition for the search.
A single search request with multiple criteria is an "and" condition search.
To get either record, you need the OR.
is there a script that can be constructed for this purpose?
I understand, but how do i do that? That is where I struggle.
Let's say for example my checkbox says 1 2 3 4 5. When I do a search for 1 and 2, I will only get the records that have both 1 and 2.
What I need is a simple option to get al the records that have 1 or 2.
You're getting exactly what you are asking for.
To quote you, "when I do a search for 1 AND 2, ... simple option to get all the records that have 1 OR 2"
then how do I ask 1 or 2
0486 38 42 83
Op 20-jul.-2016, om 19:55 heeft siplus <firstname.lastname@example.org> het volgende geschreven:
how to use checkboxes in find
reply from siplus <https://community.filemaker.com/people/siplus?et=watches.email.thread> in Discussions - View the full discussion <https://community.filemaker.com/message/587630?et=watches.email.thread#587630>
enter find mode
If the values in the check box are the only criteria in your search, you might want to leverage a fairly unique characteristics of FileMaker relationships and use a relationship with either a portal or the go to related record script step.
If you select two values in a check box field and use the check box field as your match field in a relationship, the relationship will match to records that have either 1 of the two values (or both). (Data entered into a field via a check box set is stored as a list of values separated by return characters. This behavior is the case for any such return separated list of values in a match field. The check box format is just a convenient way to create the list.)
Put the check box field above a portal based on that relationship and you can click check boxes followed by commit records to control what appears in the portal.
Go To Related records can also be used if you want to produce an actual found set of these records.
And you can use the GTRR followed by returning to find mode and constraining the found set if you need to limit the results to those matching at least 1 check box value but then also must meet additional criteria.