Hello,
I'm having trouble figuring out how to update a record from a value entered into a subform. I'm going to explain the process in plain English and my problem (I'd rate my skill in deluge as "low intermediate")
1- My "Game Score Entry" form is used to enter and update sports scores using a lookup field that contains entries from a "Team Info Entry" for the team name.
2- To keep in-game stats and attendance for individual players, I have a "Goals/Assists" subform with a lookup field that clears to include only the players (and jersey numbers) that have registered on that team from a "Player Contact Info" form. I add rows for the players that have signed in and enter their goals and assists. Clicking "Submit" at the bottom places all the data where I want it in the "Game results" and "Player Record Views".
3- Thus far, my views based on "Goals/Assists/Attendance" subforms that total the columns have been ok to use so far for tallying those values, but I think I could be doing more, which leads me to my problem- I've added fields to my "Player Contact Info" form for "Total Goals", "Total Assists", and "Total Games Attended". I've tried several different ways to try to get those fields to update when the "Goals/Assists/Attendance" subforms are entered into without success.
I've tried looking at the sample code that Zoho gives, but I've been unable to place it in context to my application.
I guess what my question really boils down to is this: My subform already clears and appends the choices down to what names and jersey numbers are available for that team, what's the next step I need to take to update the established record?
Here's a few screenshots:
If any further explanation or screenshots are needed I will be happy to provide.
Thanks in advance for any help provided
-D