I have created an Access database that is designed to send an E-Mail
out to a new student's advisor using a Mail Merge. As part of this database, I have created three tables. The first table assigns an ID number to each
advisor based on campus. The second table assigns an ID number to each active degree program in the system. The third table takes the ID numbers from these first two tables and creates a list of the programs each advisor...