Hi Guys,

Is there a way to tell FileMaker on an opening script to look into a specific folder for a file. I have two databases in my studio one in a folder called Local and another on the network(both have exactly the same databases within the folder but different data).

When a local user opens up filemaker, I want to create a shortcut that will open up my startup database from my local folder. However when a network user logs in, they will need to access only the network files. Can this be done with FM6.

Cheers

Jalz

You need to provide each user with a "Trigger File". A file whose purpose is to initiate a log-in script. The script in this file will be set to activate upon opening in the document's perferences.

Try creating a separate password for "Local" users and "Network" users and separate groups for each to belong to within the Trigger file.

Then create a script with an If statement based on the current group;

If (Status(CurrentGroup) = Local

Open (Local File) Unclick save relative path only

If (Status(CurrentGroup) = Network

Open (Network File) Unclick save relative path only

I would feel a lot better about this if the databases had unique names and not just separate folders in different locations, but I have a feeling based on your question that they don't.

Phil