External Find Script before Opening not working

[GibCo]

I have two files which I have on server with client computers. One file is logon file which checks usernames and passwords. If username and password are okay, user can go onto main db by clicking on a button which runs a script to open main db.

I use a relationship to send info from one global field in logon to another global field in main db (fields hold info I use to direct users to certain layouts based on position and access level).

In the main db some users are restricted as to which records they can browse, edit, delete through the FMP access privileges.

Problem is when the logon file opens the main file, if the first record is one that is restricted for the current user, the global field info cannot come over.

So I made the logon open main db script run an external script to Find the records the current user can access before opening the main db. Works fine on the host computer but the clients cannot get out of the logon file. Says their password cannot do that operation.

I cannot figure out what is wrong! Shouldn't I be able to do this???

Bev

[Kundinger]

Hello Bev,

I approach the development of solutions in a similar fashion as you... I utilize a