Quote Originally Posted by parry
Hi Dennis, Im questioning the practical application in using this type of control as Im not clear on what the subclasses is all about. No biggie.
Sigh...OK Parry, don't say you didn't ask for it!

I'm sure there would be many other applications that would be best served in a similar manner, but in this project it's to do with a club recorder inputting weekly archery scores and checking all these for any possible records.

There are many different types of archery "rounds" (SUB-SUB-CLASSES) and, as an example, a PART of a round (a SUB-SUB-SUB-CLASS) may include i) 30 shots @ 50m on either a "big" or "small" face, ii) 36 shots @ 50m on either a "big" or "small" face.

The recorder is thus faced with four separate columns for what appears (at a quick glance) to be the same thing - in addition to this, a round may consist of shooting the SAME combination of distance and target face 2, 3, or 4 times - these 2, 3, 4 scores have to be recorded separately and we actually end up having the recorder (in this example alone) faced with SIXTEEN almost identical column headings to choose from to enter their data and check for records - a nightmare scenario for any novice.

This can be alleviated by having two spread-sheets - one for 30 and one for 36 shots (as these are entirely different CLASSES of records), and fully resolved by grouping various types of rounds on each s/s into a smaller number of SUB-CLASSES to choose from e.g. 1) National/International rounds 2) "Clout", and to make it acceptable for all clubs, 3) Junior and 4) various "Customized" rounds.

In addition to all this...the recorder is actually working from score-sheets that have the 'Name' of the round, a date, 4 sub-totals and a total. But for record purposes this has to be analyzed a little differently. Unfortunately, there are too many rounds to just 'click a named button' for a round - this method doesn't permit customization either - and we also need to compare the sub-totals against any identical sub-sub-sub-classes that are also shot in a differently named round.

So....for this project, the recorder only have to enter the date & the 4 scores for the distances on the small 'front-end' s/s embedded on the form (a much smaller selection of column headings), a sub then reads this and presents it to them in the same 'form' they are working from (Name of the round, a date, 4 sub-totals and a total) and if this tallies correctly with the score-sheet in front of them, ALL this data is then used to populate the s/s and search for records.

I hope this satisfies your curiousity Parry?
Regards, John