Hi ! I am a beginner in FileMaker Pro and my boss wants me to write this complicated script using FileMaker Pro. Please could anyone help me go about writing this script.

The things I need to check in the script are

1. Are you a student? field (values as drop down box) says "YES"

2. Transferred field is not filled AND Withdrew field is not filled and Completed field is not filled

3. A date is entered in TO. INSTR field

4. The First Extension Expires field does not have a date in the field

AND the Second Extension Expires field does not have a date in the field AND the Expiration Date field is between 2 dates (to be entered by the person carrying out search)

5. The Second Extension Expires field does not have a date in the field AND the First Extension Expires field is filled and that date is between 2 dates (to be entered by the person carrying out search)

6. The Second Extension Expires field is filled and that date is between 2 dates to be entered by the searcher

7. Email the results of the search to [email protected]

But only include teh following fields in the e-mail

First Name, Last Name, SSN, Enrollmend Date, TO.INSTR. Course, Course Name, Expiration Date, Instructor, First Extension Expires Date& Second Extension Expires Date

If student="YES" and transferred="" and withdrew="" and completed=""

set field, TO. INSTR, date(year, month, day)

...I don't understand the rest... and I'm guessing that since nobody else has responded, that they don't get it either. Could you clarify?

BTW we have more specific forums for each of the areas of FileMaker.