I have a problem selecting the data I want to display.
Let me explain:
I have 3 databases: ADVERSAIRES; MATCH (date, opponent, match location); GOALS AND STOPS (goals scored, goals saved, date, opponents (linked to the opponent table)).
They are linked together. On one screen, I want to display the following information in the form of a list:
- opponent selection (via the opponent list) in dropdown
- list display: title: name of opponent selected above, match date; sub-title: number of goals saved and number of goals scored (from the “goals and saves” database, where there’s a line for each shot scored, whether it went in or not).
I’m actually able to display this information, but I’m having several problems:
- I have as many rows displayed as there are rows in my “goals and saves” table, whereas I’d like one row per match and opponent
- even when I have a match with 1 goal, I still have as many lines displayed as in my “goals and saves” table.
Is it possible to display one line per match and per date (knowing that we can play a team over several dates, in which case display one line per match with the corresponding number of goals for each)?
Thank you very much.