Also Cannot Constrain find

[pcjimenez]

I wonder if it has to do with my layout changing or my criteria referring to a different, yet related table.

My script goes like this:

Go to Layout ["Specific Week Attendance" (tblStudents)]

Set Zoom Level [150%]

Enter Find Mode [Pause]

Set Field [tblAttendance::dateWeekEnding[8/21/2009]]

Constrain Found Set []

this is a script that is performed after a "manual" / "user input find"

searching for a student by last name in the "tblStudents".

The tables: "tblStudents" and "tblAttendance" have a relationship by unique index key.

What it returns is the accumulated hours for each weekday of all related records, not constraining by the "weekEnding" date.

What I am trying to do is click on a specific field set up as a button which runs a script to display hours for each weekday for that specific week.

There is a script for each "school week" which was initial going to do a static find from the tblAttendance based on the date of the week ending (the friday of that week)

So week one ends 8/21/09.

There has to be a mistake in my script or my design.