J
jo
Hello,
coping with following issue:
Having table tblLevels with IDLevel (PK), IDSkill (FK), AliasLevel,
LevelScore...
AliasLevel is filled by code with sequence 1,2,3... for each IDSkill at the
time of new record addition.
Everything works fine, AliasLevel is used for displaying the table by means
of Cross Table with column for each AliasLevel.
The issue is - if user creates new records in tblLevels, AliasLevel mostly
corresponds with LevelScore (both ascending series). E. g.
IDLevel / IDSkill / AliasLevel/ LevelScore
103 / 1 / 1 / 10
104 / 1 / 2 / 20
105 / 1 / 3 / 35
..
..
110 / 2 / 1 / 25
..
..
230 / 2 / 2 / 68
231 / 2 / 3 / 99
However, I would like to secure, that even in case of later editing of
LevelScore or adding new records into the table this ascending:ascending
relation will be maintained through re-numbering AliasLevel. So if for
instance record:
232 / 1 / 4 / 22
will be added, I will change the content of AliasLevel to:
103 / 1 / 1 / 10
104 / 1 / 2 / 20
105 / 1 / 4 / 35
..
..
232 / 1 / 3 / 22
I was thinking on something like sorting the data by IDSkill and LevelScore
and consequently fill the AliasLevel, but did not figure it out...
Help would be appreciated.
Thanks in advance
coping with following issue:
Having table tblLevels with IDLevel (PK), IDSkill (FK), AliasLevel,
LevelScore...
AliasLevel is filled by code with sequence 1,2,3... for each IDSkill at the
time of new record addition.
Everything works fine, AliasLevel is used for displaying the table by means
of Cross Table with column for each AliasLevel.
The issue is - if user creates new records in tblLevels, AliasLevel mostly
corresponds with LevelScore (both ascending series). E. g.
IDLevel / IDSkill / AliasLevel/ LevelScore
103 / 1 / 1 / 10
104 / 1 / 2 / 20
105 / 1 / 3 / 35
..
..
110 / 2 / 1 / 25
..
..
230 / 2 / 2 / 68
231 / 2 / 3 / 99
However, I would like to secure, that even in case of later editing of
LevelScore or adding new records into the table this ascending:ascending
relation will be maintained through re-numbering AliasLevel. So if for
instance record:
232 / 1 / 4 / 22
will be added, I will change the content of AliasLevel to:
103 / 1 / 1 / 10
104 / 1 / 2 / 20
105 / 1 / 4 / 35
..
..
232 / 1 / 3 / 22
I was thinking on something like sorting the data by IDSkill and LevelScore
and consequently fill the AliasLevel, but did not figure it out...
Help would be appreciated.
Thanks in advance