I've got an application that contains a form (A) that has several linked parent forms (i.e. so form (A) has many drop-downs that change dynamically based upon results chosen).

I have created a stateless form for a search function. I'm now trying to search each of the fields to see if it contains the value I am searching on. I

I have create a HTML view ready to display the results (using field names and op_26 - i.e. Field1=<value1>&Field1_op=26&Field2=<value>&Field2_op=26&etc...).

However, rather than acting as an OR statement it acts as an AND statement and only returns results that fit all the criteria (like the search filter). So if the criteria doesn't match a particular field, I'm returned nothing. Additionally, I am trying to return only unique results.

Are there any suggestions on how I can return results (and I should specify unique results) if <value1> exists in more than 1 record in a different field?

This previous post goes some of the way to explaining: https://help.zoho.com/portal/en/community/topic/search-across-all-fields-or-more-than-1-field-but-with-logical-or-and-display-summary-record. However the stateless form I'm using only contains one field - and would like the search functionality to return records across multiple fields (so kinda like a search engine).

Thanks in advance for any help you might be able to provide.