Hi,
Although we have the reference number that is generated every time a new record is created,
we also want a separate job number for records that have become definite.
This means certain records will not need this new number job number.
Example:
YG1-No1
YG2
YG3-No2
YG4-No3
YG5
YG6-No4
How would I go about creating this button?
Essentially I want it so that when clicked it searches the database to find the highest number and adds 1 to it.