I have two tables. One has Student Information and the other has Meeting Information. The tables have a one-to-many relationship through Student ID.
I want the name of the student (which is stored in the Student Information Table) to automatically fill in a column after I type the Student ID number in the Meeting Information table.
How do I do this using queries?