Read & Fill FM users in drop down list !!
I have employee form and I want to assign each employee with FM user code, and fill all FM users in drop down list to choose the user code.
any idea !
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.
Don't quite understand the question. Not sure what you mean by "FM user code".
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.
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.
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.
Many thanks PhilModJunk,
Retrieving data ...