Solved

CRM - Lookup for different fields of the entity

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

This collection of functions covers all the normal rounding methods of just about any numeric value.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

732 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