I am working up a database that contains every regiment, battery (section) and squadron in the Valley campaign (Shenandoah VA 1862), their assignments at each battle, army, divisional, and brigade, all the commanders with biographical sketches, weapons with descriptions and painting notes, uniform descriptions and painting notes (with references), strength, and casualties, by battle, etc.
My idea is by using a series of linked tables with all the different information any number of different levels of data may be accessed by battle so every battle, and army, in the entire campaign is covered.
Anyone want to take a look at some of the pieces as I create them and recommend anything that needs to be added, clarified, changed, or whatever comment they want to add? When it is done I intend to share it with who ever wants it