AnsweredAssumed Answered

Modifying an "OR" find??

Question asked by fred@kca-inc.com on Jan 29, 2012
Latest reply on Jan 31, 2012 by Sorbsbuster

Title

Modifying an "OR" find??

Post

 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.

Thanks

Fred 

Outcomes