Okay so I figured something out.
I created a data macro that will automatically fill in a field with the result of a formula for me.
For example, I created an customer number using the year they became a customer and a formatted autonumber field. The field is automatically generated and locked on forms so it can't be changed.
This works great and if I can't figure out my different idea then I will just leave it.
What I'm wondering is, is there a command that can look at a field (let's call it player count) find the last number and then increment it then use the setfield command?
So for example, player count is currently 60 then the next record is added. The data macro looks at the last player count, adds one then goes into my setfield statement.
The player count is for example purposes only.