Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Relationship with Unique Value

I am trying to create a relationship between two tables. I have tried to do this and I have been receiving the error "cant create a relationship between these two columns because one of the columns m...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    Enclose 1 with double quotes (").

    Column =
IF ( [Master Column] = "", "1", [Master Column] )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

Enclose 1 with double quotes (").

Column =
IF ( [Master Column] = "", "1", [Master Column] )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you that one works for me!