hi

I have made a parent to child relation shio one to many. now i am doig delete insertion on that on a specific condition.

i have deleted the parent object then its child also deletes but after this when new record inseerted ,then autogenerated number not coming properly.


when inserting the record first time

(A)
paren table

id ,name
1 p1


child table


id fk name
1 1 c1
2 1 c2


after deletion of parent and then re-insert ith record it becomes
(b)


id ,name
2 p1


child table


id fk name
2 2 c1
3 2 c2

I want it should be inserted as it was inserting previously(a) from begining




can any one help me in this regard.