is there a way to merge two or more result sets or add existing records to a result set, i saw how to remove records from a result set.  i have a field in my record that may point to another record.what i would like to end up with is a set of records that follows the pointer to each pointed record until it stops pointing.  eg record 10 points to 6. 6 points to 3. 3 point to 2. 2 does not point. set includes 6,3,2. any suggestions?

your answer has left me no less confused.  let me explain further. i am working on a to do list (see other post) my record has five fields. 1) priority 3) to categorize and describe the task to be done 1) a pointer to the task that must be completed first,  maybe empty if no prerequisite.  i have created a form (among several) with three section 1) that displays the current record 2) a group of unbound text boxes for the prerequisites and 3) a group of unbound text boxes to display the tasks waiting for the current task to be completed.  i am using the groups of text boxes to display the data in a formatted manner. to get the information for part 3 i am using a xresultsetsearch to find the records whose prerequisite field are equal to the current record.  this part seems to be working fine, although i do keep tweaking it asmy knowledge of this program grows.  i would like to treat part 2 in the same manner as part three if possible, but am open to better ideas.

olddog wrote on Jan 28^th, 2008 at 1:23pm:


If you can type 1;3;5 into prereq on a retrieve spec and get what you want, then @XResultSetSearch should also get you what you want with that criteria.

can the result set from a xresultsetsearch be  to the first x number of matches or last x number of matches