i am looking for advice please. i wish to create a script 'a' which specifies an action based on which password the user has entered; e.g. if password=abc, perform script 'b', else if password= def, perform script 'c'. what i cant find anywhere is how to get the if statement to read the password which had been entered ...?? thanks !!!

A quirk of FileMaker is that you can't actually check passwords, but rather you check Groups. So, the first thing you do is assign all your passwords to groups.

Status (CurrentGroups) gives you a list of passwords that belong to the current group. To check a particular password per your example:

If [ PatternCount (Status (CurrentGroups), "abc"]

.. Perform Script

Else

..If [ PatternCount (Status (CurrentGroups), "def"]

.... Perform Script [c]

etc.

..End If

End If

Are you using the internal FileMaker password mechanism?

FileMaker did not include a "Status(Current Password)" for obvious reasons. But here is a workaround: Define different groups for every password you have in your list. You can retrieve the current group (and thus identify the current user "ID") by Status(CurrentGroup).

thanks .. i got it working!!!