In the first half of 2016, I began developing a complex VB.NET solution for managing a local 9 ball pool league. For the most part, EE has helped me to accomplish the coding one small task at a time. This usually involved a larger idea for a feature in the program, and I would generally give myself the assignment of breaking it down into small "doable" pieces, and if I got stuck, I would spend hours reading through various books and other on-line resources. Of course, these are often very generalized, and I found it difficult to apply it to my situation. That's when I reached out to EE for help.
Now, more than six months later, I have decided to continue my journey. Sadly much of what I thought I learned seems to elude me, but I am still pressing on.
Most of the project revolves around a complex series of tables and views which I created using MS Access. For example, there is a table for the Roster (players), another for Teams, another for the Schedule, another for Matches, and so on. These are all very relational, so I also built Views (Queries) that allow me to show the Team Name when in fact only the Team ID is stored in the Roster.
One of the features of the program is that it creates a record in the Match table once the schedule, teams and players are selected. I'm pretty sure it's the right thing to do to create the record when the match is started, but now I'm trying to figure out how to update the table with other metadata when the match is over (points, balls, fouls, innings, time outs, and other things that occur during the match but are not known at the beginning when I first create the record.
So if you've gotten this far, you should have a pretty good idea what I'm trying to do today. What I need is a good example of what the VB.NET code would look like when the 2nd write (update) occurs to the Match table. The record ID (key) is in the format YYMMDD-# where '#' is the Match number (1-5). Note that all the values needed for the 2nd write are found in various labels on the Windows Form, but the form itself is not bound to any data table.
As always, please let me know what additional information you need to help. I am not expecting ready-made code, just a good example of what I've described above.