Pull data from one table to another AND populate the record field

335 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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 🙄

0 Replies 0