Solved

CRM - Lookup for different fields of the entity

Posted on 2012-03-20
6
615 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
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.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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…

803 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