1 2 Previous Next 21 Replies Latest reply on Feb 14, 2014 1:59 PM by briancrockett

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

    JonathanPhillips

      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?

        1 2 Previous Next