Serial Number problem

[Davidatlamont]

I have a jobs database and it's set up to increment job numbers using serial number.

My wish is to have added option of duplicating job number and adding a part # when job is related.

Example- 07-0076 Fall Open House

This single job is an event that will generate numerous 'sub jobs' as in posters, programs, etc. Instead of creating a new job #, I would like to change the current record to 07-0076 01 and open up a new job, 07-0076 02.

I'm assuming I should use two fields, Job # (07-0076) and Part # (01) and have a calc field for lists that will display 07-0076 02, 03, 04, etc.

However, I'm not sure how to handle with scripts. It would seem best to have two scrips on list screen- one which created a new job number for new jobs (07-0077), and a separate script to duplicate job # and increment part # by one.

Hope this makes sense, I'm still learning my way around.

Thanks.