sequence number

[Former Member]

hi

plse guide me to solve this

there r 1500 plants eatch plant generate its own batch

ie

plant1 batch number should be counted as 1

plant2 batch number should be counted as 1

plant3 batch number should be counted as 1

plant4 batch number should be counted as 1

and so on upto 1500 plants

similarly next sequence

plant1 batch number should be counted as 2

plant2 batch number should be counted as 2

plant3 batch number should be counted as 2

and so on upto 1500 plants

next sequence is like

plant1 batch number should be counted as 3

plant2 batch number should be counted as 3

plant3 batch number should be counted as 3

this will go up to 1500 plants batch number is plant specific.

for every plant plant should give its own sequence.

plse help me out

many thanks

aaryaa

[Former Member]

Hi Madhu,

Do you want the code to generate the following output..

Or you want to create a sequential batch number.

regards

satesh

[Former Member]

hi Satesh R

many thanks for ur reply.there is no code is needed i feel so we may have to create a table,that table should be populated eatch time with locking mechanism to overcome overlaping.

many thanks

aaryaa