I have a database with 3 tables:
Assignment Groups
Managers
Users
I need a form that allows a manager to select their name from a combo box which will populate all users that report to them in another field. From there, the manager can select which users belong in which assignment groups and assign them from the same screen.
I am not sure how to start on this. I am not necessarily looking for someone to do this for me (unless someone wants to), but would like to figure out how to do it myself if possible. I cannot upload the database here, so if you want to see it, I just need to know how to get it to you. I tried populating a list from a combo box, but couldn't figure that out. And even if I did, I'm not sure how I could allow one to select users and add them to an assignment group.
Any and all help is greatly appreciated.
Assignment Groups
Managers
Users
I need a form that allows a manager to select their name from a combo box which will populate all users that report to them in another field. From there, the manager can select which users belong in which assignment groups and assign them from the same screen.
I am not sure how to start on this. I am not necessarily looking for someone to do this for me (unless someone wants to), but would like to figure out how to do it myself if possible. I cannot upload the database here, so if you want to see it, I just need to know how to get it to you. I tried populating a list from a combo box, but couldn't figure that out. And even if I did, I'm not sure how I could allow one to select users and add them to an assignment group.
Any and all help is greatly appreciated.
