ibrahimn

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

Outcomes