AnsweredAssumed Answered

Picking a specific record out of a large table

Question asked by PeterDurant on Jan 4, 2015
Latest reply on Jan 10, 2015 by philmodjunk


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.