Return to FileMaker.com
i have a table TASKS
on task layout
i have task::jobid_fk = (1) (DROPLIST FROM JOB::JOBID)
task::shipment 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
That does not make sense.
A new task record should have empty empty job and shipment number fields. They should not match to anything.
Retrieving data ...