Solved

CRM - Lookup for different fields of the entity

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now