Error : The Record already exists

(0) Share

Report

Posted on by Community Member

Dear All Experts,

i need your help,

i cant creat a new number in register check, and the error show "the record already exists"

i checked the table but the new number that i want to register is never exists.

im using debug but this error not shown

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

mmv 11,471 on at

Like (0)

Report

RE: Error : The Record already exists

Hi,

Could you share the screen print of the error?

or post the exact error and give the exact table name or id.

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (1)

Report

RE: Error : The Record already exists

reopen the table, check if there are any filters set, remove all filters, then recheck, if the number exists.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Error : The Record already exists

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Error : The Record already exists

print screen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Error : The Record already exists

Hi Jon,

i Already open the table and remove all the filter, and the result is same. the number that i want to entry is not exist

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

RE: Error : The Record already exists

ok, was the page or the base table customized?

it could be that at runtime a second record with the same no. is created before you register.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

RE: Error : The Record already exists

Hey Breketoek,

I hope you found the solution. Recently I had the same issue and finally I found out that it turned out to be the 'primary key' of the table that was causing it! I modified the primary keys of the table and it worked then!

It's all about giving some random tries!! ;)

Was this reply helpful? Yes No
AnnyU 10 on at

Like (1)

Report

RE: Error : The Record already exists

Josh Antipas I had this issue and your suggestion worked for me. thanks.

Was this reply helpful? Yes No