AnsweredAssumed Answered

Create Serial numbers starting with the value contained in a field

Question asked by fmpro_novice on Nov 15, 2014
Latest reply on Nov 16, 2014 by philmodjunk

Title

Create Serial numbers starting with the value contained in a field

Post

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?

Outcomes