Forum Discussion

Curious44's avatar
Curious44
New Member
8 years ago
Solved

Joining tables using calculated column

I am trying to join two tables T1 and T2.   T1 has a calculated column which is concatentation of fields Type and Age. T2 comes from excel and had the fields Type and Age concatentation performed ...
  • Phil_Seamark's avatar
    8 years ago

    Blanks and nulls can trip you up.  Every single value/row in the table on the 1 side of the 1:Many must be unique.   So if you can have blank values in this column and there are more than 1 row with a blank column, you will fail this referential integrity test.