Hi Guys
I need to store a sequence number that is for some “Units” is also part of the Title.
Examples:
Short Title Sequence Note S. Wales Bord. 24 the South Wales Borderers 3rd Bn, S. Wales Bord. 3 3rd Bn of the South Wales Borderers 1st Brecknockshire Bn. 3.5 A special Bn of the S. Wales Bord. Sussex Yeomanry 42 a non numbered unit 1/5th Bn, K.O. Sco. Bord. 5 the original 5th Bn of the Regt. 2/5th Bn, K.O. Sco. Bord. 5.2 2nd 5th Bn formed 3/5th Bn, K.O. Sco. Bord. 5.3 3rd 5th Bn formed 6th Bn, K.O. Sco. Bord. 6 7/8th Bn, K.O. Sco. Bord. 7.5 7 & 8th Bn’s combined, where seperate
Now, I’m showing the sequence number as a real number (not an Integer) to allow for easy mental conversions. Some regiments expanded into the 20’s for Bns, with up to 4 Bns doing the splitting thing, making an integer sequence number conversion “interesting”.
Note the 5th Bn was title that until the 2nd 5th was formed.
Note that the Americans use a different Ordinal number system (st, d, th) in their titles.
Now the question to the group “is the sequence number a separate field?” I ask that because in most cases It can be derived from the title (or the other way around), but not all. The Title record will be stored as a multi field entity to handle additional data (eg. nick names, full names, abbreviations, formal names, service, branch, etc.).
All comments welcomed