Picking a specific record out of a large table
I've asked a similar question in the past but am still struggling with a problem of picking a specific record out of a list and populating a field, I'm hoping someone can help. What I have is a table of people who have attended specific events. The table includes 30 million records, in the configuration of one record per person per event. I have a separate database with all the people who could have attended the events and I created a field that can display the name of a specific event that a person attends. Once the field is populated, it will never change.
I linked the tables together by unique ID for each person, but because the first table contains one record per person per event any time I populate the field it only populates it with the first instance of that person showing up in the first table. How can I specifically pull the person for a specific event?
Very frustrating for me. Thanks for any help.