Hello,

I've used FileMaker a bit but have something which I am hoping is a basic question. I am working with a scheduling database that organizes appointments for a school guidance office. Each day of the school week gets a new record in the 4-digit year format -- DD/MM/YYYY. I am familiar with startup scripts and wish to use one to enter find mode when the database starts up, auto-enter the current date and search the system for that date's schedule so that counselor's the correct schedule when they open the database each morning.

Any help is appreciated

Basically you'll want this in your startup script:

Go To Layout (layout to search)

Enter Find Mode

Set Field [dateField ; Get (CurrentDate)]

Perform Find

Also, you may want to Set Error Capture [On] for the sake of a nicer user interface.

Edited October 7, 200520 yr by Guest

Thanks a million :)