October 14, 200619 yr 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?
October 14, 200619 yr 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
October 14, 200619 yr Author 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.
October 14, 200619 yr 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
October 14, 200619 yr Author 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)
October 15, 200619 yr But, ehrmm....I dissagree! http://www.filemaker.com/help/ScriptsRef-231.html --sd
Create an account or sign in to comment