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?