Okay, here's what I want to do:
I have a FMP Server running a TON of databases, some are related, most are not.
I want to create a login database (edulogin) with two fields: login and password.
Then, a second database (edupermissions) with fields: login, database, and permission.
edupermissions will relate to edulogin using the field "login". Therefore, for each database that a user has access to, there will be a record in the edupermissions database, including a level of security located in the "permission" field. (everybody got this so far?)
Basically, edulogin will be related to edupermissions with a "one to many" relationship, using "login" as the relationship field.
SO, a user opens edulogin, it brings them to a screen that forces them to enter a login and password. A successful login will bring them to a screen with a portal displaying all the related records in the database edupermissions showing them which databases they have access to, and a button for each to open that database. With a press of the button, the system will then open that database with the password listed in the "permission" field.
With that in mind, this is what I'm having problems with:
How do I script it so that FMP will open a file from the current server and the file will be named in the field "database".
Kinda like:
Open [Open hidden, "<<database>>"]
The other thing I can't seem to figure out is how to specify the password to give to that file when it is opened (transparently to the user) by pulling it from the field "permission".
I would like to avoid having to add an If/Then statement in a script every time I add a new database to the server. However, if that's what I have to do, that's what I have to do. As far as the password thing, I'm completely at a loss.
If I have been unclear on anything, please post and I'll do the best I can at explaining the situation.
Thank you in advance!