Okay, I’m on a thinking weekend and working with ideas which I haven’t solved or thought hard about.
tblUnits has UnitID. At some point (maybe after unit deceased) it is given BattleHonours. Another UnitID will be assigned to perpetuated those honours when the assigned unit is deceased.
So this gives a tblHonours, and tblUnitHonours. Should there be a UnitPerpetuates table? Or is there a another way assigning the honours.
What I’m thinking is should the perpetuating unit be assigned directly or look it up though the true units?
Hope this makes sense