I'm writing a small search tool that searches a SQL Server database using Full Text Indexing.
I have two text boxes with four radio buttons between (NEAR, OR, AND, AND NOT)
Ex. CONTAINSTABLE(jobs, *, ‘computer NEAR California’)
This works fine but if I start adding more text boxes\radio buttons (As pictured in attachment) this starts to get messy...
I need to display or represent brackets to allow correct searching:
Ex. CONTAINSTABLE(jobs, *, ‘computer NEAR California’ OR ‘drive NEAR building’)
Any ideas on a simple way to modify the form to encompass this?
Thanks.