AnsweredAssumed Answered

Trouble with relationships / relational data

Question asked by rfaintich2013 on May 21, 2013
Latest reply on May 22, 2013 by philmodjunk


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!