If the file is already open, it is brought the front.

If the file is closed, FM says, "The script cannot be found or has been deleted." The only option is to click "Okay." Then, the requested file opens and displays another error: "The previous script step, “Open File”, could not be completed because of an error. Do you wish to continue with this script? Option to Continue or Cancel.

What the heck and I doing wrong and is there an error log somewhere that I can access?

If the file is closed, FM says, "The script cannot be found or has been deleted."

That message mesas that FMP cannot find the file. Check the file reference in the external data sources.

Where is the file that is being opened? Does it live on a networked file share?

Continue with what script? It will be a lot easier to help if you post the files or at least the scripts.

Both files are in the same folder. And it FMP can't find it, then why does it open anyway?

File name: Domains

Script has one simple step: Open File called Invoices.

A CLUE: I think this might have something to do with renaming my files as I save my progress while building this database (ie. Domains and Domains2. That being said, I'm still asking to open a file that really does exist.

It sounds like the Invoices file has a startup script of its own - check under File Options.

THAT WAS IT! May a bounty of blessings shine upon you for many days. Back story: I'm trying to upgrade from FMP v6 (yes, I know . . .) and I'm having to literally recreate everything. It's rather painful but will be worth it when I'm done. Thank you so much.