1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. “Item Column: Must have non-unique records” – BACKTRACK Error Message

“Item Column: Must have non-unique records” – BACKTRACK Error Message

Summary

This article explains the BACKTRACK error message “Item Column: Must have non-unique records” and details how to fix the underlying problem that caused it to appear.

Explanation

When performing a add/move/delete to a record on BACKTRACK, the error message: “Item Column: Must have non-unique records” appears.  This error message indicates that there are more than one or more records in the database that contain the same unique identification number or key field.

Solution

The best way to fix this problem is to use SQL management studio, run a query on your database, determine which record(s) contain the same identification number, and delete the undesired record.

SQL solution procedure:

Run SQL management studio > connect to your database > create a new query > input the following:

SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

Execute the query > select the entire row of the undesired record > right click and delete the record.

Additional Comments

Error messages first appeared: BACKTRACK 2012.00.02

Updated on July 29, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support