How do I add a script that runs upon the user opening the database over FM Server running in OSX? I just want to find all records and create a new record.

Furthermore, when the user quits the solution, I want to ensure that a script runs.

Hi Jason,

Put the opening script in File Options > 'When opening file, Perform Script.'

Put the closing script there as well, under 'When closing file, Perform Script.'

:wink:

Ooops. User. Do you also need to capture the User in a global gUserAccount field? Then your opening script can fire depending upon the User. I'm a bit unsure of which you need but I hope it helps anyway.

Put the opening script in File Options > 'When opening file, Perform Script.'

It's a little more complex than this. This routine does not necessarily guarantee that the script will run. If this is a critical routine, then you have to go beyond this step to assure that the script does run.

Steven

Beyond in what way?