Add and update a column in the Form_View

Add and update a column in the Form_View

Hi everyone,

I have created a simple form which contains of 3 fields:
  1. Single line: Name
  2. Dropdown: Goals
  3. Dropdown: Assists
When a user fills in his name in the 'name field' he has to select how many goals and assist he registered in a ice hockey game.

It is obvious that there are multiple games in a season.

The situation is it is now:
Every time a player fills in the form a new record is added in the database...


Situation as it should be:
Every time a player fills in the form the 'goals' and 'assists' has to be updatet.
So that there is just one single record for each player in the database.


Can someone please help me with this?