Please give an example of what you need to see happen when a user logs on to your database and why. Then we can make a detailed response telling you how to do what you want. (Or we might suggest a better approach to get the same results )
In general, a script can use Get ( AccountName ) to identify the account used by the user to access the database, but what happens next depends on what you need and what you have currently set up in your database.
Well i figured out how to script accounts to layouts. Now i need help with a couple of things for this. The database i made is split up into three parts; Inside Sales, Verifier, Outside Sales, and Managers.
1. I have set up 50 possible accounts for inside sales to login to. Each account is scripted to go to a particular layout that equals the account name. The accounts names are permanent and can NOT be modified since they are attached to a navigation script. I want a way to create 50 user names that can be added, changed, or deleted by managers. The idea is that a manager can creates a user name and assigns it to one of my 50 accounts. The username wil then populate in every layout created in that particular account. If needed, the manager can change something or delete the user without ever deleting the account itself.
ex: John Doe walks into the call center and says, "I want a job." the manager logins on his side, clicks [add user] and sets up John Doe. John Doe is then given by his manager a login and password. The login navigates to a layout that says, "welcome John Doe." in addition, every time he creates a new record, his name will automatically populate under a field named "repersentive." but then, one day John Doe tells himself he can't do it anymore and he quits. In walks Jan Doe and she says she wants a job. The manager simply logins under his account and clicks [delete user] some how he deletes John Doe and adds Jan Doe. Manager gives Jan Doe the same login and password and now her layout says, welcome Jan Doe. Keep in mind that this would have to support 50 users and web publishing.
2. The second thing I need help on is actually an extension of the fist thing I mentioned above. I need a way for a manager with none admin privileges to be able to add these usernames delete them and change them if needed. Also, I want his layout to be able to somehow assign the username to any of the 50 accounts without bugging me. In addition, I need a calculation that would someone stop the manager from assigning a new user to an account that's already in use by another user.
plz note that's any solution has to work with web publishing. Also, the user names can be fields created in a table. I am not talking about the system usernames but if I can use that to assign multiple names that would be perfect. Also plz refrain from using a solution that deals with relationships. I have exhausted myself in trying to set up relationships with other tables. I simple just do not get it. lastly the users added and deleted would have to connect Somehow to a value list that would show up in other parts of the database. The idea is that when a manager adds a new user that info will show up in a drop down menu in another department using a different table.
I see that you've opened a new thread for this and I've responded there...