Community
Showing results for 
Search instead for 
Do you mean 
Reply

Where is the current number in a sequential field stored? - ACT Custom Table

New Member
Posts: 1
Country: USA

Where is the current number in a sequential field stored? - ACT Custom Table

Hi,

 

We use ACT Custom Tables for our service desk. In one of our tables we have a field called Ticket Number which is a sequential text field. Currently, we have nearly 2000 tickets in the table, however recently our ticket number had been reset back to 0.

 

image.png

 

I tried going into the field setting however because the field type is now blank, I cannot get to the next screen to change the initial number

 

image.png

 

To temporarily get around the issue, I created a program which gets rid of duplicate ticket numbers and gives it a new number which isn't being used in the table.

 

My question is, where about does ACT pick up what the next ticket is? Is it in a SQL table? Is it in a file somewhere in the database directory?

 

Once I found where this number is, I can then manually change it to 2000 to stop the duplicates

 

Thanks,

Brandon