how to get the next serial number (conditional V)

Discussion created by ibrahimn on Apr 23, 2017
Latest reply on Apr 23, 2017 by philmodjunk

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