firebirdta84
Technical User
Hey guys,
Need a little bit of help with this one. I have a table (tblCases) containing about 100,000 records. Each record has a ten digit number in the field called Case_Number. This data in this field is not unique; a single Case Number can exist in multiple records. I also have a field in tblCases called ManifestID. This field is blank. What I need is to automatically update ManifestID to equal the Case Number plus a two digit number at the end that would be unique for each matching case number. So, for example:
CASE NUMBER MANIFEST ID
-----------------------------
1123456789 112345678901
1123456789 112345678902
1398774809 139877480901
1123456789 112345678903
The unique 2 digits at the end must only be unique to the Case Number; i.e. the two digits can be the same if the case number is different.
Any help would be appreciated.
Thanks!
Joe
Need a little bit of help with this one. I have a table (tblCases) containing about 100,000 records. Each record has a ten digit number in the field called Case_Number. This data in this field is not unique; a single Case Number can exist in multiple records. I also have a field in tblCases called ManifestID. This field is blank. What I need is to automatically update ManifestID to equal the Case Number plus a two digit number at the end that would be unique for each matching case number. So, for example:
CASE NUMBER MANIFEST ID
-----------------------------
1123456789 112345678901
1123456789 112345678902
1398774809 139877480901
1123456789 112345678903
The unique 2 digits at the end must only be unique to the Case Number; i.e. the two digits can be the same if the case number is different.
Any help would be appreciated.
Thanks!
Joe