Job Numbers in unrelated table

Discussion created by cowens1 on May 8, 2012
Latest reply on May 9, 2012 by digital-carpentry

In writing a new file I'm wishing to have serialized job numbers in a table that no user sees.

Then when a user in a Layout hosted in Table B OR a Layout hosted in Table C needs a new job number they would retrieve the new number from the JobNumber table and also make sure the JobNumber is incremented for the next access.

Any ideas how to best accomplish this?

(probably elementry to most / many of you... but dang, I'm still on the bottom tier of what looks like a very steep learning curve)