AnsweredAssumed Answered

Modifying an "OR" find??

Question asked by on Jan 29, 2012
Latest reply on Jan 31, 2012 by Sorbsbuster


Modifying an "OR" find??


 Good Evening,

I'm trying to create a found set from an "OR" search (initial found set) then constrain the set with a value in a separate field (found set 1).  This part works great:

Enter Find Mode

Set Field1 to 1

New Record

Set Field1 to 2

Perform find [to get all records where Field1 = 1 OR 2][initial found set created]

Enter Find Mode

Set Field2 to 1

Constrain Found Set [to get all records with (Field1 = 1 OR 2) AND Field2 = 1)][found set 1 created]

This where I run into trouble: At this point, I'd like to get back to the "initial found set" (without redoing the initial query) and set Field 2 to 2 and re-query to get found set 2

Is there a way to do this?  The inital found set query actually has a loop to build the OR function.  Ideally, I'd like to not re-query this due to time constraints because it will have to be done 4 times.