Hi Guys
Playing with my data (currently British WW 1 info) for import, and I have noticed that my tplTitles may not be setup optimal.
Currently the table is:
plTitles:=> TitleID Formal Full Short Abbv
The unit which follows:
1) had 6 versions during the war and this is the end war one (1918 Nov 11)
2) it's 1 out of 78 divisions plus others units
3) Each line is a (sub)Unit with 9+ tables referencing it.
4) Every abbv. could (should?) be a Title record
5) the number of repeated parts and abbv.
So the question is Do I breakup Titles? and if so How?
51st (Highland) Division X.51 T.M. Bty., R.F.A. Y.51 T.M. Bty., R.F.A. 400th Eng Fld Coy., R.E. 401st Eng Fld Coy., R.E. 404th Eng Fld Coy., R.E. 8th (Pioneer) Bn, R. Scots. 255th (Highland) Bde., R.F.A. A Bty., R.F.A. B Bty., R.F.A. C Bty., R.F.A. D (H) Bty., R.F.A. 256th (Highland) Bde., R.F.A. A Bty., R.F.A. B Bty., R.F.A. C Bty., R.F.A. D (H) Bty., R.F.A. 152nd (1st Highland) Brigade 152nd T.M. Bty. 5th Bn, Sea. Highrs. 6th Bn, Sea. Highrs. 6/7th Bn, Gord. Highrs. 153rd (2nd Highland) Brigade 153rd T.M. Bty. 6th Bn, R. Highrs. 7th Bn, R. Highrs. 6th Bn, A. & S. Highrs. 154th (3rd Highland) Brigade 154th T.M. Bty. 4th Bn, Sea. Highrs. 4th Bn, Gord. Highrs. 7th Bn, A. & S. Highrs.
Where some abbv. mean
Seaforth Highlanders (Ross-Shire Buffs, The Duke of Albany's) Gordon Highlanders Princess Louise's Argyll and Sutherland Highlanders Black Watch (Royal Highlanders) Royal Scots (Lothian Regiment) Royal Filed Artillery Royal Engineers Trench Mortar