close related files only if hidden?

[Factory Pilot]

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.

[Fitch]

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

[Vaughan]

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.

[Fitch]

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