I vote that thiere is a DB for Judging attendance that shows by Sanction Body (FBA, KCBS, etc.) by Judge Title (Master, Certified, etc.) by Judges last & first name and Postal Code (ZIP). That is a DB with 6 fields as follows:
-Sanction Body: (LOV/Drop Down List - 10 alpha Numeric Characters)
-Judge Title: (LOV/Drop Down List - 10 alpha Numeric Characters)
-Last Name: (20 Alpha Characters)
-First Name: (20 Alpha Characters)
-Postal Code: (Zip) (5 Numeric Characters)
-Event(s) No Show (Not Including Proper Cancelations): (Intiger Numeric 2 Characters)
The software I am writing is designed to be generic enough to be used by any sanctioning body, with any criteria, any scoring system, and any type of competition really. It would be a bit more complex than what you list as it would have the complete address, phone, mailing address, some form of CBJ number.
To make it work across organizations, should some one want to track that would not be super difficult, but each entity (cook, team, judge) would then be assigned a unique identifier and a cross reference implemented so that a judge in one organization could be found in others. If people want me to move ahead with what I discussed earlier, I'll accept lists of judges form any sanctioning body and store them accordingly. Every one is welcomed to suggest fields to attach to those judges, and we'll go from there. This can feed into the larger comp management software really.
Also, I would love to track scoring for trending, but just don't think *I* am the person who should be entering that data and able to view it. If any one can come up with a way to allow that to happen where I am not "The Man" with access to all judges' scoring history, I'd love to have it...sorry, wrong thread. Maybe we need a web page so that organizers and reps can upload files, but I'd still have the database on my computers.
dmp