hello guys
i have a table that contain 3 fields
1- serial number
2- sub serial number
3- number
4- description
Serial Number | Sub Serial Number | Number | Description
1 | 1 | 1200 | Empty
2 | 1 | 1546 | One 1200
3 | 1 | 1652 | One 1200 - Two 1546
4 | 4 | 1750 | Empty
5 | 4 | 1890 | One 1750
what i want is
for example serial number 1 - 2 - 3 have the same sub serial number which is the number of the first record of this group in the first one the description is empty in the second one the description will contain the number of the first record in the third one the description will contain the number of the first record and the second record
i need this because we have files with updated information so we should entered again but in the same time linked to the old data of the same file
N.B: the sub serial will be manual entered because every file the serial number will be writed on the file
any solution?
i have a table that contain 3 fields
1- serial number
2- sub serial number
3- number
4- description
Serial Number | Sub Serial Number | Number | Description
1 | 1 | 1200 | Empty
2 | 1 | 1546 | One 1200
3 | 1 | 1652 | One 1200 - Two 1546
4 | 4 | 1750 | Empty
5 | 4 | 1890 | One 1750
what i want is
for example serial number 1 - 2 - 3 have the same sub serial number which is the number of the first record of this group in the first one the description is empty in the second one the description will contain the number of the first record in the third one the description will contain the number of the first record and the second record
i need this because we have files with updated information so we should entered again but in the same time linked to the old data of the same file
N.B: the sub serial will be manual entered because every file the serial number will be writed on the file
any solution?