Division 1 - Job Numbers are 2000TL and up, (example)
Division 2 - Job Numbers are 50000TL and up (example)
When making a new Job Number, i will select which division the job number will be created for.
ant it will keep track of auto-incrementing the job numbers as a new one is added… The problem is, i dont want to create 2 tables to track jobs, just want to one table.
How can i implement this?
Example: Next Job Numbers Avaiable
2011TL was last used, so 2012TL is next IF for Division 1
50064TL was last used , so 50065TL is next, if Division 2
Are the letters (TL) fixed? You could create one table called ‘Factories’ with just two lines for the two factories. Columns in here would be the base number (static) and a field which increments based on a lookup count back to a table of items - ie shows the total number of items in factory x plus one (the next item number). You could use a template to add on your prefix and suffix.
When you create your new item in the items table use a relation/lookup through an action (eg on form submit) to take the ‘next’ number on the factory table and add it to the field on the items table.
Wow. Duh.
Each employee has the capability of writing a labor ticket. And have their own assigned Ticket number.
Each ticket they create in increases by one.
I can use this same concept, exactly how you explained, is exactly how im already doing for that.
Cant believe i didnt think of that! Thank you so much