Solved

CRM - Lookup for different fields of the entity

Posted on 2012-03-20
6
621 Views
Last Modified: 2013-11-25
I would like to lookup different fields for an entity, how would I do that? How many relationships do I define?

e.g.

Plan Entity
PlanName, PlanAccountID, PlanDescription
I would like PlanName, PlanAccountID map into name, AccountID for the Plan Registration Entity when I do a lookup in PlanRegistration Entity
0
Comment
Question by:tommym121
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 37742128
When you create a relationship between two entities, CRM adds a lookup field on the child entity of the relationship (e.g. 1:n relationship between Account and Project, Project is the child entity). The lookup field references the parent entity using the primary field which is generally a name field. You can't choose which field is used.

If you want to have multiple lookups to a parent record then create multiple relationships.

But I'm not sure I fully understood your question, perhaps you could elaborate please?
0
 

Author Comment

by:tommym121
ID: 37742191
I am doing a manual N:N relationship.  e.g.  Client have multiple plans, Clients can share same plan.  I try to have a registration Entity to do the N:N relationship.  I would like to have some information from Client or Plan to show up in registration entity.

Doest that make sense?

In a relationship, you can also define the  mapping does that mapping help me to achieve what I have if I define one relationship but multiple maps within the mapping>
0
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 37742649
I'm assuming that the registration entity is the intersect entity.
When you add an registration record to a client from within a client record, then you can use mappings to copy fields from the client record to the registration record. The same applies to Plans. Make sure that you have fields of the same type in clients, plans and registrations and then create mappings in the appropriate relationship.
You can have multiple mappings but not more than one onto the same field.

In views for registrations you can show fields from the parent entities. If you are only concerned with views you may not need to copy fields across.
0
 

Author Comment

by:tommym121
ID: 37743047
"mappings to copy fields "  how to you do that?
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Read about achieving the basic levels of HRIS security in the workplace.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question