There is a bug in the view designer which prevents me from creating the SELECT I want to use because it scrambles the parenthesis. I am creating an application with a search which allows the user to enter multiple substrings and retrieves these records. Ordinarily, the SELECT statement would look like this:

SELECT {fields}
FROM {table}
WHERE ((table.subject = m.Term1a) OR
(table.subject = m.Term1b)) AND
((table.subject = m.Term2a) OR
(table.subject = m.Term2b)) AND
(table.subject = m.Term3) AND
(table.subject = m.Term4) AND
(table.subject = m.Term5)

The user can enter 5 terms, the first two of which can be one field OR the other (For entering a word and an abbreviation. The last three are single terms used in the search.