Data assist search, need to group search criteria

Hi there

I have a table with a list of records which i am trying to filter using the database search

my fields are (not these actual names just so you can see what data i have)

artist
recordType
defaultCollection
collectionAside
collectionBside

the search i am trying to do is as follows:

artist name begins with a specific letter (from a get variable)
AND
record type = specific criteria (from a get variable)

in addition to the above

i need to check if ANY of the following match

defaultCollection = specific criteria (from a get variable)
OR
collectionAside= specific criteria (from a get variable)
OR
collectionBside = specific criteria (from a get variable)

if i was doing this manually i would simply have AND then the following in brackets:

AND (defaultCollection = * or collectionAside = * or collectionBside = *)

is there a way to do this with he database search, or can i edit the code created to achive this?

thanks for your time