Can anyone advise me BEFORE I jump into creating a database and becoming frustrated? It would be a big help to get advice before doing anything. For instance:
Combat Command Database:
This database records the components of a group, not the individuals, though that would come later (think of the individuals as members). So, a user would select from checkboxes that will comprise the components of a battle group, once done, click submit. There would therefore be a summary page showing the components of each group the user could click through using previous next buttons.
Checkboxes would be for army components:
Check the item desired and enter the quantity desired: Stuart Light Tanks, Sherman Tanks, Self-propelled howitzer tank, SP halftrack, 37mm Antitank guns, etc. Even down to how many stands of infantry in the group and what kind: Rifle, Heavy Weapons, LMHeavy Mortar teams, jeeps, trucks etc. Then I suppose there'd also be a field for history which would be just text, and a field for commander name and even the name of this unit, e.g. Kelly's Heroes.