AnsweredAssumed Answered

My list just shows the first record and does not include all the items I need.

Question asked by JonathanPhillips on Feb 14, 2014
Latest reply on Feb 14, 2014 by briancrockett

Title

My list just shows the first record and does not include all the items I need.

Post

     Hi,

     I am trying to make a field that lists all events that an athlete has won. Currently, I can only get the first event that an athlete won.

     To explain further, I have an athlete table (athletes) that includes all the basic details such as name, club, age.

     I then have a results table (results) where I fill in the results of an athlete in a competition; picking the athlete's name from a value list and then entering data such as position, event and result. 

     On the athlete table I want to list every event in which the athlete has a position of "1". Can anyone help me in doing this?

Outcomes