-
-
2. Re: Read & Fill FM users in drop down list !!
Don't quite understand the question. Not sure what you mean by "FM user code".
-
3. Re: Read & Fill FM users in drop down list !!
Thanks Ron Cates for reply,
FM Users mean when u want to add new users u have to go security and add the users, just i want to retrieve all users that create thier in security and fill them in drop down list, that what I need to do.
-
4. Re: Read & Fill FM users in drop down list !!
nobody knows !! any idea !
Or maybe the ones that know don't live in your time zone. That post came in at 5:11 AM by my location.
(And I rarely access the forum over the weekend...)You'll need a table of AccountNames for this. (I don't recommend usernames as these can be changed in preferences and be different from the accountname/password used to access the database.)
Get ( AccountName ) will return the account name of the current user.
You can either use a scripts and layouts to manage the creation of each new account and these scripts can create a new record in the account name table each time a new account is created, or you can set up a script that runs each time the file is opened that captures the user's account name and checks it against the table, adding it to the table if it is not found to already exist in the table. Your value list of names can then be drawn from this table.
-
5. Re: Read & Fill FM users in drop down list !!
Thanks PhilModJunk,
you give some good ideas, but until now I want to choose all users from Value List.
Get (AccountName) just return current user, if something like this .. Get ( AccountNames ) that return all usersName will be better.
My regards.
-
6. Re: Read & Fill FM users in drop down list !!
That's what it does exactly, but it's purpose is to set up that table of account names. Then you can define a value list to list all account names from this table.
-