Forum Discussion

JENS's avatar
JENS
Frequent Visitor
9 years ago
Solved

Regarding relation between 2 table , must have unique values

Im new at this, and have tryed to read the other solutions regarding the same queastion. error : You Can´t create a relationship between these two columns because one of the columns must have unique...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi JENS

     

    I assume you tried to establish a relationship between both emplid columns.

    If [EMPLID] in EMPLTABLE is unique & there are no nulls in EMPLTABLE[EMPLID], it should work.

     

     

     

  • ovetteabejuela's avatar
    ovetteabejuela
    9 years ago

    Why not make a unique employee table if none of the two are.