Sequence Number Generation in Forms Builder 6i
Posted on 2004-11-29
I'm using sequence number in one of my forms which is basically a master-detail one and the sequence number field is the primary key. I have created the sequence number in the databse with the increment of 1. I'm using the initial property of the field so that the every time a new record is inserted, a new sequence number is generated. My question is that, I only want a new sequence number to be generated when the user clicks on the insert record button. In this particular case, when users only run query, the sequence numbers are generated and when they actually insert a record then at least 6 numbers are missing.