darkroast
Member
Possibly this is easier than I think, but I'm looking for some suggestions on the best way to handle the following scenario:
I have a database table with an association name and a manager (which is a dbjoin from another table). When an association is transferred to another manager, I want to create a form which allows me to select the association from a dropdown; based on the association chosen, the current manager will be displayed (read only). Another dropdown will also show a list of managers, where I can select the new manager.
Once I submit the form, the manager is updated in the database, and I am sent an email that says something like "Please transfer [association name] from [old manager] to [new manager]."
Basically, someone else will fill out the form. I want to automatically update the database, and send me an email like the above to let me know to change the manager in a completely different system (which I do manually).
Any thoughts?
Oh, another possible addition to this process: each manager has a "team lead" which is stored in the table used for the dbjoins above. Sometimes, the new manager has a different team lead. If, and only if, that's true, I'd like to add a message to the email that's send reminding me to change the team lead in the second system as well as the manager. This would be nice, but not missions-critical.
I have a database table with an association name and a manager (which is a dbjoin from another table). When an association is transferred to another manager, I want to create a form which allows me to select the association from a dropdown; based on the association chosen, the current manager will be displayed (read only). Another dropdown will also show a list of managers, where I can select the new manager.
Once I submit the form, the manager is updated in the database, and I am sent an email that says something like "Please transfer [association name] from [old manager] to [new manager]."
Basically, someone else will fill out the form. I want to automatically update the database, and send me an email like the above to let me know to change the manager in a completely different system (which I do manually).
Any thoughts?
Oh, another possible addition to this process: each manager has a "team lead" which is stored in the table used for the dbjoins above. Sometimes, the new manager has a different team lead. If, and only if, that's true, I'd like to add a message to the email that's send reminding me to change the team lead in the second system as well as the manager. This would be nice, but not missions-critical.