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
If the prefix changes however (T1 to T2, or P1, etc.)
You can create a table with all of those records, and then create a relationship between the table. Then use a filtered report to only show the "Next Sequence" that hasn't been used yet.
Thus you can have a very complex or simple sequence of IDs
You can create a table with all of those records, and then create a relationship between the table. Then use a filtered report to only show the "Next Sequence" that hasn't been used yet.
Thus you can have a very complex or simple sequence of IDs