Error : Field "Shelf No." should be in Item table

ajaybabuCh

Hi

When I am trying to rename the Item No. , it is giving me the error
"The field “Shelf No.” must be included in the table’s primary key in the Item table".
I activated the debugger. but its straight away giving the error without stopping at any code.

I put check marks on both Active and Break Point On Triggers , first its validated "No." field and then went to "On Rename" trigger , after that throws the above error.

Can any body give me a solution , why I am getting this error.

Regards
Ajay

ara3n

export all modified objects to txt and search for "Shelf No.".
My guess some field out there is linked to item."Shelf No." field and you can't link to a non PK field.

MChilari

Hi Ajay,

Rashed is totally right. There is a field in the database which has a table relation to Item."Shelf No.".

To find out the field, create a new form based on "Fields" Table(2000000041); filter on "Relation Table No." and "Relation Table Field No.".

Thanks
Mohan