Before I launch into this it would be good to define just exactly what I mean when I refer to editing. Most of would say that editing records means changing what is stored in a set of table rows, and the edit process does encompass that functionality. Beyond that, however, it is important to recognize that an essential component of the information contained in these records is their sequence, as embodied in the inning_order column. It is not at all difficult to envision a context in which records need to be inserted into that order, deleted from it, or moved around in it. As that record sequence is as much a component of the information stored in the database as the values stored in any of the columns, modification of that order is an important editing function. Since, however, the inning_order value is maintained automatically during entry, the modification of that value should be accomplished in some form other than expecting the user to manually modify the inning_order value.

First, however, I am going to incorporate the functionality required to modify the contents of the rows already entered, after which I shall incorporate the functionality to modify the recorded order of events.