Data Entry Validation

[Halsley]

I am trying to implement a script that before running will ask for the user to enter their name and password. These entries need to be checked against another table/list and if their entries to not match the ones in the list, the script won't run. If it does match, then it will run.

It was suggested to me that I use lookups.. but I am not sure that is the right option, since I am not really wanting to copy the name/password information into the current record.. I just want to make the check before the script runs.

ANY HELP

[Moon]

Set up a db, Names And Passwords, with the respective text fields, Names, and Passwords as text fields. Create a record and enter a name and associated password for each person you want to be validated.

Password-protect to keep these fields hidden unless the master password is entered.

In your main db, create a user password that will also be in the Names and Password db.

In the main database, create a global field, Name, and global field, Password

Create two relationships to Names and Passwords:

Relationship A. Name = Name

Relationship B. Password = Password

Next, ceate a short script that you can invoke in the main script you wish to use the name/passoword test. Let us name it Check Password:

If

not isValid(Relationship A) or

not isValid(Relationship

Halt Script

EndIf

Then in the script you want to control, enter a script step,

PerformScript (Check Password)

I am winging this so you may need to tweak this. (Heck, right now I have a lot simpler script I haven't gotten to work and have asked for help in the Scripts forum.) But this is the basic sense of scripts I have used in the past to check first before continuing a script.

[ April 12, 2001: Message edited by: Moon Mullins ]

[ April 12, 2001: Message edited by: Moon Mullins ]