Help with Similar Key
I have a database that I picked from sample templates "Contact Management". It has the capacity to find similar contacts by Name, Company and City. I added Type. I then added a "k_similar_Type" field copying the model from the other fields. I added the Type field to the field inicated as k_similar_multikey and I also added a relationship from Table Contact Management to Table similars_by_Type using field k_similar_type.
After all my contacts are in, one group of contacts in a type indicated as GOVT does not appear with all the other GOVT types and I do not understand why. They have different company names and different cities but they all have GOVT as the type. Shouldn't all the GOVT types appear with all the other GOVT type contacts? What is missing? any ideas to help me?
Thank you in advance