Auto increment in card form

Hi,

I have a field in the card form as 'Serial no’ and it set as ‘Integer’ in the related table filed and autoincrement set to YES.

I do not know what else needed to be set to make the auto increment work in this card form, it is not working in my card form.

Any body ??.

Teeyech,

Is it a existing field or new field?

is it a primary key?

Are you using code to assign values?

It’s a new table, new form and new field.

It’s primary key.

I did not use code yet, I am beginner, too much researches I got to do.

I thought it like, there may be option in the property for the auto increment.

I just created a new table and form with autoincrement field and its working fine

did you show the field in form?

try to validate the field.

just press tab on primary key…

form property visible set to ‘Yes’ , and its visible and editable.

try to validate field, am not that clear about it, - ValidateTableRelation set to yes.

when I press tab, it shows message as ‘No. must be filled in. Please enter a value’.

Hi,

I could not find the solution yet,… [:(]

i think there’s something missing. it seems, abdul is working on form, are you?

if yes, so it’s the problem. you need to set it on the table.

Hi Joe,

Sorry for late reply, it was my 2 days week offs.

‘AutoIncrement’ property set to Yes in table for this filed.(field name: ‘No.’ )

any other property needed to be set ?

good day,

Teeyech

Take a look into the Line No. field property in table & form.

But if you set all the things ,the Serial No. will start from 10000 default.

Hi,

I have created a new table and form, it is working in that.

I had to do nothing but to set the autoincrement property to ‘Yes’ in the table, then form increment worked fine…

But why not in this form ??.[^o)]

At the beginning, this field’s type was ‘code’, later I changed it to integer… is this may be the reason ??.

Teeyech.

Hi,

I have created a new table and form, it is working in that.

I had to do nothing but to set the autoincrement property to ‘Yes’ in the table, then form increment worked fine…

But why not in this form ??.[^o)]

At the beginning, this field’s type was ‘code’, later I changed it to integer… is this may be the reason ??.

Teeyech.

Thank you all,

It’s done now !.

Teeyech[:)]

Yes,It applies to only Integer and BigInteger Data types only