First describing my goal and the way I’m trying to setup my tables, so looking for a critique on the process (maybe there’s a better way I could be doing this?) but also looking for a direct answer in regards to auto populating a record when added through a linked table.
Goal: Every year I put a conference together and I want to make the booking process easier by having a full database of past speakers, years they spoke, and targets for next years’ conference in terms of who I want to speak.
I created a “Speakers” table, which has the names and all of the contact information about each speaker. I also created a “Years Spoke” table, which lists all of the years I’ve done the conference.
I also created an intermediary table, which I’m calling “Master List” which will list all of the speakers, years they’ve spoke and gives me the ability to quickly sort the list by years spoke, etc.
Am I building this process correctly?
When I add the name of a speaker in the “Speakers” table, I want it to auto-populate in the “Master List” table. How can I do this?