I have a very simple solution that contains the following 3 tables:
I want to send some emails to selected students and I have that part pretty much handled.
The question I have is do I need to create a relationship between the SMTPs table, EMAILS table, and the STUDENTS table.?
The SMTPs table contains a separate record for each SMTP server that I can use to send out the emails.
The EMIALS table contains one record for each email that I may want to send out. There's only 3 fields ID, subject, and body.
The body has the text that will be in the body of the email with some codes that I put in that I will replace with fields from the students table, such as, <<NAME>> will be replaced with their actual name.
Appreciate any suggestions.