Auto update values in a form based on values in another

Auto update values in a form based on values in another

Hi Guys,

I hope you can help me with this please?

I have two forms: workflow_jobs and workflow_job_types, the two forms are linked via a look-up field called job_type - when a new job is created, it's manually assigned a job_type value.

What I'm trying to achieve is, when a new job is created and on success, a script runs through the workflow_jobs form and updates the field current_jobs in the workflow_job_types form with the number of jobs for each job_type.

Example:
So in the view job_types I'd be able to see how many jobs there are by each job type:

Job type:            Jobs:
Print                        2
Desgn                     3
Marketing                6

and so on...

Is this possible?

Thanks,
Martyn