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

    how to get the next serial number (conditional V)


      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