Create Serial numbers starting with the value contained in a field
I have a database that creates serial numbers automatically upon record creation. My current serial number is 10,500. I have a global field that shows the current serial number.
On another layout and table, I have the ability to add to this database. When I add to the database from this layout, I want the new serial numbers to be created based on the global field showing the current serial number.
Ideally, I could check Serial number, then Next value would be the global field that shows the current serial number, then increment by 1. Is this even possible?
Can someone tell me how to add a serial number starting with the value in the global field that shows the current serial number?