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.
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.