Serializing a field

[mozum]

can any one help me on how to make a field accept number input serially. For instance if serial number of a preceding record is 3, the field should accept 4 as the next record else error msg should request a re entry as serial number 4.

[htuser]

Hi Mozum,
Please consider using autoincrement item.

Auto_increment.jpg

For error message, please try visualvalue function with this idea:

Code: Select all

if item value<> visualvalue (previous item value)-1 then 
errmsg();

[/i]

Best regards,

[mozum]

Thanks alot for the guide. but I could not access the author increamental field to check it. I try to do so by right clicking on the field and selecting field property. But it display among other items 'sequential' which is unselectable. can I still learn from you how to display this.

[savy]

Only numeric fields are allowed to have autoincrement attribute. Please check your dictionary and make sure that the item is numeric type and not alpha

[Gregory Martin]

Auto increment fields can only be ID fields. If you want to increment a non-ID field, you might consider using the loadsetting/savesetting function to store the value associated with the previously entered case.