Field Error

bekiobekio Member Posts: 204
I have a serious problem with Navision 2009.
At table Item I have added field 50007 'xxxx' Decimal. And when i try to modify an item "No." in Item Card(or Item Table), for example "No."=00001 to "No."=A00001, it displays this error :
'The following field must be included in the tables primary Key
Field: xxxx
Table: Item'.

I hope that you can help me in resolving this problem.

Thanks for help!

Answers

  • bekiobekio Member Posts: 204
    I have deleted these field from Item table, and i get another error "Field number 50007 is not defined in the Item table".
  • kinekine Member Posts: 12,562
    1) First error is because you set the table relation of some field to field, which is not primary key. E.g. when connecting to table Item, you can only connect to field No., not e.g your own field.
    2) It means that you are still using the field somewhere, e.g. on page or form...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bekiobekio Member Posts: 204
    Thanks a lot Kamil Sacek ,

    I have resolved that problem!
  • kinekine Member Posts: 12,562
    You are welcome... 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.