Want to let user type password one time and the solution shall contain over 1000 passwords, which enable the app after their valid pass.

First time it is asked for the password which bypass that password layout the next time. I put all the passwords in a Case() formula, but there seems to be a limitation on how many results there can be in a Case(). It will not accept all of them.

But I get all passwords in a valuelist and for me it seemed right to try formula, ValueListItem(dbname, valuelist) in a

If ["passwordfield = ValueListItem(dbname, valuelist)]

Iam not able to test this because it won't recognize my current dbname.

Would this work at all, this way?

Thanks,

(I assume you've a file in which password are stored)

There was a limit to the number of statements that could be nested (around 60) but it has been lifted/removed in FM 6

The function you use might work:

Say your list is named PasswordList; the formula

PatternCount (ValueListItems(Status(CurrentFileName),"PasswordList"), EnteredPassword) >0

will return true if the entered password is among the values of list PasswordList

Another (probably simpler) method of checking might be that of creating a relationship between EnteredPassword and Password and using the formula

not isEmpty(Relationship::Password)

that will return true if the password has a match

Thanks, Pupiweb!

The Pattercount() formula did it.