Forum Discussion
cnpdx
8 years agoHelper II
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...
cnpdx
8 years agoHelper II
I tried the Match function, which gives me the relative placement of the name in the list. How does that help me?
Rfranca
8 years agoResolver IV
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.