9 Replies Latest reply on Jan 27, 2016 5:10 PM by Mike_Mitchell

    Can I run a "Find" using "Checkbox set" criteria as an "OR" statement?

    ErickJ.Gonzalez

      I have a DB for community resources where agencies/programs are categorized by service type.  I have a “Service Type” field as a  “Checkbox Set” with the following options:

      Health                 Transportation              Heating Assist.

      Advocacy            Academic                      Career Develop.

      Legal                   Mental Health

       

      (Some agencies/programs offer services in more than one category)

       

      Is there a way that I could run a “Find” using a “Checkbox set” as an “OR” statement? In other words is there a way I can run a “Find”, select more than one box in the "checkbox set" and have the “Find” return all the agencies/programs that have any of the selected boxes?

       

      i.e. "FIND" any agencies/programs that have/offer these services:

      x Health                 x Transportation              Heating Assist.

      Advocacy            Academic                      Career Develop.

      Legal                   x Mental Health

       

      (If I do this now, I get all agencies/programs that have/offer all three selections.)

       

      Is it possible? If so, what’s the best way?


      I know I can run a “Find” and select x Health,

      click “New Request” then x Transportation,

      click “New Request” then x Mental Health, and

      then “Perform Find” which will return all the entries/records that have any of those options selected.