i create a table and a "table type forms" but when i key in the data it shows data already exists

[jliang84]

Hi all,

I am facing the difficulty when keyin the data to my newly create table (using my newly create table form). Anyway for me to keyin the 2nd data with the “Code” is empty?

[manjusree]

Hi

‘Code’ is the primary key of your table and you cannot have two records with the same primary key.

[jliang84]

anyway to make the “code” set by the system whenever i add a new record??

[manjusree]

You can write code in OnInsert trigger of the table.

[jliang84]

code… oh no… any example?

[jliang84]

or any clear guideline to guide me to do so?

[jliang84]

i manage to make my “code” running in auto numbering already (integer)

But i noticed that if i click on “show all” it wont show my table’s Record

did i missed up any step for my form?