Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
    9 years ago

    Anonymous,

     

    Enclose 1 with double quotes (").

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

The formula returns the same error that I was returned previously for me.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
9 years ago

Anonymous,

 

Enclose 1 with double quotes (").

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

    Thank you that one works for me!