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

ajaybabuCh
ajaybabuCh Member Posts: 208
edited 2007-11-20 in NAV/Navision Classic Client
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
Ajay

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • MChilari
    MChilari Member Posts: 47
    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

Categories