Displaying and sorting in a database


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.

Hi @Ezo,

Welcome to the community :partying_face:

Could you explain a bit with some screenshots or a from a video?

Thank you