Forum Discussion
JENS
9 years agoFrequent Visitor
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...
- Anonymous9 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.
- 9 years ago
Why not make a unique employee table if none of the two are.
ovetteabejuela
9 years agoImpactful Individual
Why not make a unique employee table if none of the two are.
JENS
9 years agoFrequent Visitor
that might work, but im unsure how to make it.