Finding Next Sequence number in a field
We are using a alpha numeric field in a table similar to : T1-001. How could I ensure that for a new record created, next available sequence number is available to a user in this 'required' field. I...
Forum Discussion
The easiest way is to make a formula which uses the Record ID#
For example
"T1-" & Right("000" & ToText([Record ID#]),3)
For example
"T1-" & Right("000" & ToText([Record ID#]),3)