I have to contruct a search but have only got half way
I need to search on a form and get results for
(fieldA = a, fieldA = b, fieldA = c, fieldA = d) OR (fieldB = e or fieldB = f)
which is the easy bit
I now have to run an extended search with a NOT for the same fieldA and FieldB
(fieldA = g, fieldA = h, fieldA = i, fieldA = j) OR (fieldB = k or fieldB = l)
Is it an OR NOT or and AND NOT
(fieldA = a, fieldA = b, fieldA = c, fieldA = d) OR (fieldB = e or fieldB = f) but not these
(fieldA = g, fieldA = h, fieldA = i, fieldA = j) OR (fieldB = k or fieldB = l)