Locking Releationship file!!

[tmas73]

I have a 2 file filemaker db one the main app the other the releation ship file. Is it possible to open the file only through the main file?? I do not want that the user can open the releationship file.

Thanks

TMAS

[ernst]

When the database is accessed via a network, you can prevent the user from seeing the file in the 'Open host' dialog by making the name start with an underscore, i.e. _filename.fp5.

If the files are to be used locally, the you can have a startup script in the related database that checks if the main database is already open, using the 'databasenames' design function, and if not, close the related file again or perform the startup script in the main database.

Regards,

Ernst.

[tmas73]

YEs seems your suggestion number 2 is the one i look for. The only problem is I don't know how to use he databasenames function. (Main db file = dvready.fp5, releation db = scenes.fp5)

Is it like

If["DatabaseNames=:?"] ------Dont know whats going here!

Close ["scenes.fp5"]

else

Perform Script [sub-scripts, "Startup"]

End If

Thats where I got stuck.

Could you post a small example??

Thanks ernst

TMAS

[-Queue-]

If PatternCount( DatabaseNames, "filename" )

Close ["filename"]

End If

To see for yourself, set a global text field with DatabaseNames and then examine it.

You can also Set Multi-User [Hidden] in File->Sharing (when you are the host) or set the last character of your filenames to an underscore, as well.

[ernst]

Quoted from the Filemaker Manual:

In FileMaker Pro 4.1 and earlier, you could prevent a file from appearing in the Hosts dialog box by adding an underscore character to the end of its name. Now this can only be accomplished by using the Multi-User (Hidden) sharing option. When converting version 4.1 or earlier files to the current version, FileMaker Pro will set the sharing option to Multi-User (Hidden) when it encounters filenames that end in an underscore. This preserves the relationships and scripts in these files.