You have 10 statuses (statii?) Does each record only have 1 status or can each record have multiple statuses?
For example, would a report be something like, "show me all records that have Status 1, OR Status 2, OR Status 4", or "Show me all the records that have Status 1 AND Status 2 AND Status 3"?
Thanks for your response. Each record can only have one statuses at a time.
I think its AND.
For example, if user selects statuses pending, active and cancelled.
The report must find everything that is pending and everything that is active and everything that is cancelled.
Manually it would be a add new find requests, I just don't know how to take the users selection from the checkboxes and convert it into different find requests.
Thanks for your help
The global, check box formatted field could be a match field in a relationship to an occurrence of the other table. Then Go To Related Records could be used to pull up a found set of all the records with any of the selected status values.
There's a looping script example in the following link that shows how to set up a script that loops through the values in the check box field in order to set up a find that will find any of the selected values in the global check box field:
This seems to work to just find the checkboxes, I would also like to do the search based on additional find criterias such as date, so statuses selected plus the date.
Based on this example
Set Variable [$FruitList ; value: Globals::gFruitList ]
Enter Find Mode 
Set Variable [$K ; Value: $K + 1 ]
Set Field [YourTable::Fruit ; GetValue ( $FruitList ; $K) ]
Exit Loop If [ $K > valueCount ( $FruitList ) ]
Set Error Capture [on]
is the correct place to put additional set field for the date field after the Exit Loop If?
You would put those set field steps inside the loop so that each find request is identical except for the specified check box value.