Can anyone help me write a script that allows me to find a set of records within the last found set.

I have 100 total records for surgical procedures.

I have a spreadsheet with totals for # of successes, # of males, # of females, average age, race, diabetics, smokers, etc.

I have written scripts that will find just the number of successes and show the totals of males, females, etc.

Now within that found set, I would like to further break down the data. For instance, how many of the successful procedures were performed on diabetic males, or smoking females, etc.

Basically, I am asking whether it is possible for a simply Find Records script to function within the most recently performed Find Records script, or will I have to write an infinite number of Find Records combination scripts.

Does this make sense?

Thanks.

Check out the constrain option. It performs the find on the current found set and constrains the results to matches from that set.

thanks Brill