G
Guest
I have just created a table for our documents reference, in which we want to
start a new serial number each year without creating a separate table each
year.
Kindly let me know how I can do that in which the starting value is 1 each
year as primary key and adding a year value to it to make it unique.
Treat me as in intermediate level when explaining how it is done.
Regards,
Hanadi
start a new serial number each year without creating a separate table each
year.
Kindly let me know how I can do that in which the starting value is 1 each
year as primary key and adding a year value to it to make it unique.
Treat me as in intermediate level when explaining how it is done.
Regards,
Hanadi