Find using Global or Calculated fields

[S.A. Moor]

Is there away to perform a Find Script in a database (or database table) using a global field or a calculated field that stores the result of the global field?

[Søren Dyhr]

Well just do it, but it's going to be an unindexed search ...you have formulated your question too vaguely, I dare say that the reply largely depends on what you really want to achieve, is it a search in records with invoices due???

--sd

[S.A. Moor]

I've a database that contains the names of a few users, each one of them has an ID a passe and fields that define some actions he or she can do (some of them run external programs). I've a password dialog in which the user must enter the ID & the password, (which I store in global fields). Then I would like to disply his/her related information on the screen in a dialog using the information from the fields after I localised him/her using the information I've in the global fields.

[Søren Dyhr]

Why store the password in a global field when a correct login knows of a name to display with Get(UserName) which in an unstored field can act as primary key for a GTRR(SO) This is pretty easy to establish, but you can also restrict which records a user can access via the setting of the privileges.

--sd

[S.A. Moor]

There are too many users who are going to use the application, on the same machines. I can never tell who will they be, the application has quit a few databases and it will be a tendious task to add and remove each time the Get(AccountName) or Get(userName). for that reason I've created a user's list with the names, passes etc..and I'm switching layouts by giving Consult or Rights rights. for that reason I would like to enter the application with a non FileMaker password (user ID/Name +a pass)

[Søren Dyhr]

But, ehrmm....I dissagree!

http://www.filemaker.com/help/ScriptsRef-231.html

--sd