I have a vertical table.
I have a column with a Certificate #:
I would like to have the # sequential
I have to make a separate table for numbering?
It is base on:
Where tblAffiliation.Affiliations = '3A' (Folder)
Cntr3 (int, null)
Number starts with 1 - 9999 is current on what is in the tblAffiliation.Cntr3 Column
so something like: Max(Cntr3) + 1?
Trigger is best way to handle this?
with an external table to keep track of the sequential #?
Cntr3 column is not sequential to All Folders (3A = 1 Folder) it is only sequential to one Folder 3A .
this table has multiple folders and the numbering is separate.
So I will need a separate table to keep track of the sequential number based on 3A.
So where Affiliations = '3A' then do the sequential numbering on Cntr3 Column.
Here is some data:
Contact1 Contact2 Affiliation Cntr3
1720 10631 3A 1
1720 10631 3A 2
4 10129 3A 4
12 10134 3A 12
17 10136 3A 17
20 10138 3A 20
25 10139 3A 25
26 10141 3A 26
29 10142 3A 29
25 10140 3A 31
26 10141 3A 32
26 10141 3A 33
I need help with the setup on this?
Please help and thanks...