Trouble with relationships / relational data
I'm sure there is an easy solution, but I have not been able to figure out this problem.
In short: I have a table with a relationship to another table, based on the name of the athlete. A field then displays the matches that athlete participated in. That's been acomplished. What I haven't been able to do, is set other fields to the proper value, based on the specific match. What is happening, because the tables are related based on the Athlete's name, is that it is only displaying the value for another related field (for example, number of touchdowns that athlete had in specific match) of the first matching result, based on the name, from the main table.....
So, how do I specify that the value of a field is linked to the specific match? I have not been successful for several hours, and ANY help is tremendously appreciated!
Thanks so much!