My list just shows the first record and does not include all the items I need.
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?