View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Serial Number problem

Followers

September 26, 200718 yr

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.