I came across this post searching for the exact same thing as Blake.  Seeing as how it has been 5 1/2 years and still no AND/OR logic in lookups, it doesn't seem to be getting any love.  

Just in case it helps the cause at all, here is my use case:

We have many different types of leave plans but an employee can only have one.   I only want my form to return the information for whichever plan the employee has.  I would love to be able to specify something like:

When EmployeeID = HrID 

AND

When LeavePlan = 'SS06' OR 'SS08' OR 'SS07'

Then

AccrualField = AccrualRate

Maybe a feature that could be coming soon to a Laserfiche near you!

We have a Form that teachers will be filling out that we have tied to a PowerSchool Oracle database. We then have the teacher select the following:

1. What school they are from.
2. Their name from a populated list
3. What section they are selecting children from

When they select their name from the list it is performing a lookup based on the School ID that was selected as well as if the teachers Status = 1.

We have some hard coded fields for the Year, TermID1, TermID2, and Trimester. We would like to be able to also filter the list of teachers based on if the values in those fields also apply. The Year and Trimester values would need to use AND logic. The TermID1 and TermID 2 values would need to use OR logic.

We need a way to specify that logic when creating the conditions.

Hi Blake,

Rather than handle this from the Forms end, it sounds as though it could also be handled on the Oracle end.  Forms 9.1 supports stored procedures, which you could use to create the "OR" logic behind the scenes.  You might want to check out the help files for more information about working with stored procedures.  If that won't work for you, please elaborate a bit on the use case, and I'll be happy to file a feature request for you.

If the interface can resemble what the Field Rules uses where a user can specify "When (Any/All) of the following is true: ..." that would be ideal.