how do i setup a script to run on 'open'? i would like to limit the amount of records shown to users by finding only records pertaining of interest to them. i basically have to "Find records where FIELD equals VALUE" but i want this done automatically to increase user experience. any ideas? cheers!

Edit->Preferences->Document

Select the General tab and then define your on open options.

WOW! that was quick and to the point! thank you VERY much!

Startup script is not executed, if the file is opened from relation or by calling script.

i can't seem to perform a script that will find certain records automatically... any ideas?

Perform your find manually. Create a script with Perform Find [Restore] in it. If you ever need to change the criteria, perform another manual find, open the script, close it, and select 'Replace' to the Find requests option.

Startup script is not executed, if the file is opened from relation or by calling script.

...unless the calling script uses an Open ['Filename'], of course.

-Queue- thank you!

Sure they will be cases when yes and when not

IMHO -- better is to open all files in single starting file. That gives better control.

Or, to test for the existence of a file that might not currently be open, and open it if necessary:

If [not PatternCount("