1 Reply Latest reply on Apr 23, 2017 7:45 AM by philmodjunk

    how to get the next serial number (conditional V)

    ibrahimn

      hi all

      i have a table TASKS

      on task layout

      i have task::jobid_fk = (1) (DROPLIST FROM JOB::JOBID)

      task::shipment no = (1)

      visit no(1)

       

      i need when i'm on a new task

      if the task::job_fk

      and the shipment.no    are the same of another task

       

      increase the task::visit = value with 1

      if the last value was 1 it will be 2

       

      and if it was a new shipment for the same task::jobfk

      the visit will be 1

       

      i hope you understand me

       

      thanks alot

       

      Ibrahim NABIL