First, if this is not place to ask about this software, forgive and please point me correct location.
I am setting up a beer competition using Brew Competition Online Entry & Management (BCOE&M) system.
We want to accept all BJCP styles, but have predefined categories of awards. How best to set this up? (note, this is an example, so not looking for debate on how I assigned styles to award categories, just how to set up in software ;D ).
Example
Award 1- Pale Ales: includes: 16B Belg pale , 10A amer pale, All of cat 8 English pale
Award 2 IPA All of cat 14 IPA
Award 3 Lagers –1A Amer lt, 1B Amer standard, 1C Amer Premium, 1E Dort export, All of cat 2 pilsners, 3A Vienna lager, 4A dark american, 4C schwartz, all of cat 5 bock
:
Award n Fest/ Fall Beer 1D Munich Helles, 3B Oktoberfest/ Marzen, 4B Munich Dunkel, 21 A Veg Beer –MUST USE PUMPKIN, Anything can be entered in here but must specify why it is a fall or fest beer
etc…
Is this how tables are used - I would define the tables for each award I would want, and then assign flights of the appropriate styles to the tables.
Thoughts?