opening files by script

[jccollins]

I currently have a program that contains a template file. When the User starts a new project they input the project name. A script then creates a folder and a copy of the template to this folder and renames it the project name:

i.e. ....JohnsonJohnson.usr

I save the path and file name in global fields.

I had wanted to then open this new file without futher user input, but gave up on that. I am now just trying to have the Open File function open up in the new folder. I have tried all sorts of ways, to no avail. Can't get the default directory off the last opened table without user input. Any ideals?

Thanks

[comment]

It's difficult to imagine circumstances that would warrant users creating a new file - especially when they cannot be trusted to open said file. Seems like you are utilizing spreadsheet methods with a database.

Why not simply have the user create a new record in the Projects table and continue from there?

[jccollins]

The files are generated in "the field". The design has been in place for some time. Just tring to make it a little simplier. Users are certainly capable of "clicking" back one folder and then selecting the folder that was just created but would have liked to "spoon feed" them, if possible. I will take it that it's not an easy process. I was just hoping I had missed something. Thanks for viewing.