Forum Discussion

cnpdx's avatar
cnpdx
Icon for Helper II rankHelper II
8 years ago

Error when creating a relationship

Hello, I am trying to create a relationship between all my tables using "account name unique" (which should be unique), and my other tables, such as "account name" in the opportunity table (it's a Z...
Need Help
cnpdx's avatar
cnpdx
Icon for Helper II rankHelper II
8 years ago

I tried the Match function, which gives me the relative placement of the name in the list. How does that help me?

Rfranca's avatar
Rfranca
Icon for Resolver IV rankResolver IV
8 years ago

cnpdx

 

When the MATCH () function does not return error this means that all records have their respective relationship.

 

Use the COUNTIF () function to check how many records are related between each table. The result must be 1 for all rows.

Also check empty line this can cause in errors in the relationship.