Title
Read & Fill FM users in drop down list !!
Post
Hi there,
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 !
Read & Fill FM users in drop down list !!
Hi there,
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 !
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.
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.