October 26, 200124 yr Newbies 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!
Create an account or sign in to comment