Unique custom field in Item table


I have found similar Post on this forum but none of them were resolved, that’s why opening new one.

Navision 5.0 MS SQL 2008

I would like to have unique field(Custom Field ‘External Id’ which is text field) on Item table.

What I’ve done so far:

  • in Navision Created new Key in Item table through → Object Designer->Item->Design->Keys
  • in MsSQL2008 set this key from index to unique

However when I insert new record with same External Id it doesn’t comes with any error message and simply creates this record. Which ends up with 2 duplicated entries.

Could you tell me what I am doing wrong?

Regards Ondrej

You have posted it to AX forum, it should be in NAV