No unique index found error message

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ishancolumba
    New Member
    • Jun 2015
    • 2

    No unique index found error message

    i have the following tables and would like to create relationship but it shows that no unique index reffered.
    pls help
  • ishancolumba
    New Member
    • Jun 2015
    • 2

    #2
    The 'code' field from 'items table is the primary key. I would like to create a relationship between 'TCode' from 'Items and 'Tcode' from 'traders table. But when I enforce integrity, it says no unique index found. The 'Tcode from Items Table is indexed to Yes(no duplicates) while Tcode from Traders is indexed Yes(no duplicates). It still shows error pls help

    Comment

    Working...