I have a Table that lists everyone who has taken our leadership courses (Participant table). Fields include Participant Name and FLL Attended. I have a second table listing everyone who is a salaried leader in our company (600 records). I want to have a column (field) in the Salaried Leaders table that shows if they have taken our FLL course. How do I set it up so that the Salaried Leaders table links to the Participant Table AND populates the field with the class they took? I know I can do a linked record, but then I have to manually select and that is inefficient.
I know the answer is probably pretty simple, but I just can't get there on my own 🙄