line number already exist

jhanvincent14

Good day, I need help for this kind of error. this error occurred when I press the arrow down key every time. this packing result fast tab is a list part of this page.

mohana_cse06

What is the primary key of the table and field datatypes?
Please check the prerequisites of Autosplit key

mohana_cse06

screenshot is not available.
Did you set autosplit key property yes?

RockWithNAV

Hey,

As per the screenshot it seems to be a Primary Key Error. Check the Auotosplit Key Property it must be yes and if error still persists debug and check which piece of code is creating this error. Have you written any custom code as well?

jhanvincent14

I didn't write any custom code . this error occurred when I'm pressing the arrow down and I don't know how to debug this. because there is no trigger for this.. I already set the autosplit key into yes and still im getting this error

mohana_cse06

What is the primary key of the table and field datatypes?
Please check the prerequisites of Autosplit key

mohana_cse06

Please check whether you have 10000 record already in table.

Kishorm

As the BPR Packing Result table is a child table, the Primary key should be "Batch Number,Line No." - it is only "Line No." at the moment so it errors because line 10000 already exists for a different batch.

rajavenkat74@gmail.com

Definitely Just Said Like Kishorm... Primary Key already Exist It would be Batchnumber Null , product name Section

jhanvincent14

Thanks by the way I only Change the data type of my table column and it works