I rredesigned my database so that a individual can have multiple awards instead of entering a award in every single instance. Folowing are my datafields of the two tables. I have the relationship as a one to many relationship from soldier ID to Soldier ID. Here are the fields.
Soldier Id LNAME FNAME Rank Command Unit Position Title GradeType GradeLevel
Awards Given Fields
Award Id Soldier ID DateReceived DateApproved DatetoTag DatetoAcc TypeofAward Dollaraward Hours GradeStep FYAward StategicObjective Notes