[SOLVED] Search using Checkbox field

I have a grid that I’m trying to setup a search for. My field is a Checkbox, so it’s values are 0 and 1. I can’t seem to find a way to get the field to show up as a checkbox, so that either they can check it, or better yet, have the field equal true or false. The search does work if I use 0 or 1, but my users probably won’t know how to make that work.

Use the lookup on the field to display what
You want to display to the user but use a one or zero to the search

Kev

Thanks, I will try that out.
Been a few years since I’ve used SC, little rusty.

Thanks, that worked.