Forum Discussion

joschultz's avatar
joschultz
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Relationships

    I keep getting an error that tells me I cannot create a relationship between two tables because one of them has to have unique values.  Can someone explain this to me? Don't you need to join th...
Need Help
  • GTR's avatar
    GTR
    10 years ago

    A unique value is a column that does not contain any duplicates, thus unique. 

     

    UNIQUE             NOT UNIQUE

    1                         1

    2                         1

    3                         2

    4                         3

    5                         1

     

GTR's avatar
GTR
Icon for Helper III rankHelper III
10 years ago

A unique value is a column that does not contain any duplicates, thus unique. 

 

UNIQUE             NOT UNIQUE

1                         1

2                         1

3                         2

4                         3

5                         1

 

joschultz's avatar
joschultz
Icon for Advocate II rankAdvocate II
10 years ago

That makes total sense.  Thank you!!!!