I need to perform a scripted find on a set of records that limits the results to only the current day's date.

My theatre reservation database has two operations: A "reserve seats" part which allows the operator to mark seats as they are phoned in; and a "will call" section which allows the operator to mark the seats as occupied on the night of the performance. The first section allows for reservations to be made for any of the performances that weekend.

The second section is used as patrons come to pick up their tickets on the night of the performance. I need to be able to find a patron's reservation by their last name, but I don't want to see records from any other performance except the current night.

The fields are "Performance Date" and "LName"

Any help would be greatly appreciated!

If you want to use a script with a button,

Enter Find Mode - pause (unclick restore)

set field (Performance Date) to Status(currentDate)

go to field Lname

continue

Thanks! I appreciate the quick response.