Hi, I am trying to make an app to record my golf score.
I have a tab named “Add Round Data”.
Here, I put date and golf course name, which are columns in my Round Data Table.
Clicking on submit takes to a new form.
The form can add row into my Hole Data Table.
Here, I put hole number, hole type and number of putts.
What I want to achieve is that if I click a button, then
- the hole data that I put is added into the Hole Data Table, and
- the same form is now clear and I can put another hole data so that I can use the same form again and again.
- when I am done with adding the hole data, I submit and all 1 to 18 hole data are added. (I made a relation between Round Data Table and Hole Data Table.
However, the problem is that the add row button seems unable to understand the data I input in the form. It just makes me add static data or data I previously put in Hole Data Table.
What would be the possible solutions?
Please help me I am helpless.