Dear alex

as i have already got suggestions from your side for the past conditions,
now there s a critical conditions to be newly wriiten for that label , can
you plz give  me some codes to print this label..

my table :

workorder     Quantity in serialNo     StartingSerialno

101                       20                              1
102                       30                              1
103                       25                              1
104                       50                              1

Table structure:

1.the  quantity(Serial no) field  for the particular Workorder which is fixed.

2.the StartingSerialno field  all the values are set to  1  Default.
(changes whenever user enter the StartingSerialno which are above the stored
value)

condition:

1.promt for WorkOrder :            101

2.prompt  for starting Serial no :   10

here if a  user enter the value 10, then it should be saved in the database
for the  StartingStartingSerialno field. whenever the user changes the
starting serial no , if it is above the stored value in d/b it should  be
saved in the database.

3. promt for ending serialno:      20

4. promt for no of copies     :      2

print label.
note : this example is for First time changing the Starting serialno  from
default 1 to 10.

since the Quantity for the WOrkorder is  20 ,  the  user can  enter the
follwing

startingserial no =10
ending serialno=  20

everytime the startingserialno changed by the user the quantity remains same
for the workorder and the Quantity  must synchronise with the changed
StartingSerialno

then it should print with workorder 101

with the serial from 10  to  20 in the label report.

the above example is first time changing the S'Serial no  

after update  my  table :

workorder      Quantity in  serialno      StartingSerialno

101                       20                              10
102                       30                              1
103                       25                              1
104                       50                              1

main thing is that  when another user take the print out ,he cannot enter
the startingSerialno below 10 for the

same workOrder  101  

and it is understood that user can print label with

starting serialno     10  
ending serialno      30  

no of copies           2

plz give me some codes to manipulate this ,Hope u understand my conditions
in the table.

regards
Niyaz

riyazny@gmail.com

hi alex

can you plz provide me the Code for the following condition( Newly modified)

table structure:

workorder     Quantity in serialNo     StartingSerialno

101                       20                              1
102                       30                              1
103                       25                              1
104                       50                              1

all the Starting Serial no is set 1 Default,(if I change this 1 in future to
some values ,it should  Shynronize  with Quantity (Maximum limit of ending
Serial no).

Prompt For Workorder:  101

promt for Staring Serial no: 2  
Promt for Ending Serial no:  20
no .of copies   : 1
then it should Print  like this

101  101   101   101  101   101  ......101
2      3      4       5     6       7           20

plz make note that the field Quantity in Serial no  is the maximum limit for
Ending Serial no ;

in the above Example i have given the value (Starting Serialno) 2 to  
20(Ending Serial no)

thanks & Regards

Niyaz

riyazny@gmail.com