Well. let me start by higlighting the problem i face.I have two columns namely PID which is the primary key and also a auto number.The second is Serial No. which is also a auto number.
The problem i face is that when i submit my form spcifying a month i want my serial no. to start from one and and end with the number of records in my Datagrid.
IF i come to the same and select a different month the PID should continue from where the last auto no. is but my serial no should start from 1 again..
Is there any option to do like this.Both PID and Serial No. are in the same table.