I have created a database for teachers to access their student's records. I want the teachers to be able to send out mail with their SMTP configuration, nowever each teacher has their own email accounts. What is the best way to create a multi user solution to accomplish this?
I have created a user table with the accountname as the ID. Then my thought was to create a relationship with the student table based on the accountname. The user table would then house the SMTP info. Am I going about this the right way or is there a better way to do this?
Thanks for your help!