Is there a way to close related files only if they're hidden? I've got seven database files that are related in various ways. If I close one of the main files, say file A, I want it to close the rest of the files so they're not left hanging open in the background. However, if I also have one of the other main files, say file B, open and _not_ hidden, I'd like that to stay open when I close file A and close any of the other 5 files that are not hidden.

Tricky one! Doesn't look like FileMaker provides a Status function for this, but you can do it with an AppleScript.

tell application "FileMaker Pro"

if exists menu "(FileName)" of menu "Window"

close database "FileName"

end if

end tell

Define a script in the main database:

Close (related file a)

Close (related file

Close (related file c)

Close (related file d) etc

In the main database, go to the Document Preferences and set this as a shutdown script. now when you close the main database all the related databases in the script will also be closed.

Vaughan, he only wants to close them if they're hidden!