Find and Constrain

[MHAriete64]

I'm writing a script to find students who've not taken a specific course (Classes::Course) and have taken a prerequisite (Classes::Course).

I've set up a layout for administrators to select from a value list the course they'd like to "fill" (set variable $TempCourseToFill) and then a place for them to tell me that course's prerequisite (set variable $TempPreRequisite). I want FM8.5 to omit the people who've taken the class, and find just those who've taken the prerequisite.

Can I get a few ideas of how to go about this. My avenues have failed.

Thanks.

Edited May 8, 2007 by Guest
clarification

[sbg2]

New Script =

Enter Find Mode[]

Set Field[studentClass::Course; $TempPreRequisite]

New Record/Request

Set Field[studentClass::Course; $TempCourseToFill]

Omit Record

Perform Find[]

In short... find all students who have taken the prereq. course and then omit those that have already taken the course to be filled.