Remove From My Forums

MS CRM 2011 ONLINE - Inheriting from lookup

Question
0

Sign in to vote

I have an entity which connects an account and a license number. I have customized the order entity where are look ups for the account and the license number.

Now in the order when I look up the license number, I want to inherit also the account related to license number and also some other fields. How can I do that?

Can someone point me to the correct path with real code examples?

Thursday, August 15, 2013 9:33 AM

All replies

0

Sign in to vote
Hi,

Do you want to fetch the Only Account related to Licence Number entity or Want to fetch fields as well of Account related to Licence Number?

You can construct the QueryExpression or FetchExpression to Retrieve the records. To fetch the related records attributes you have to Join the related record using LinkEntity.

Refer blog for this.

http://msdn.microsoft.com/en-us/library/microsoft.xrm.sdk.query.queryexpression.aspx

Hope this helps!

Thanks!
- Proposed as answer by Kalim Khan Sunday, September 1, 2013 6:26 AM
Thursday, August 15, 2013 9:59 AM
0

Sign in to vote

When I look up license plate, I want to populate also the customer (account) related to license plate. Also I want to populate a two options field (not in the picture) and maybe some other fields straight from the customer (account).

And definately in this order. First license plate.

Thursday, August 15, 2013 10:17 AM
0

Sign in to vote
Hi,

You have to write JavaScript that will fire on change of license Plate. The JavaScript will perform the below operation.

- Read the License Plate value.

- Retrieve License Plate and Account related information.

- Set the Account Retrieved from License Plate

- Set the Fields Retrieved from Account.

You can achieve this through Odata Or Soap JavaScript.

For OData refer below blog. Using Expand you can fetch both License plate and related account information in one Query.

https://community.dynamics.com/crm/b/mahenderpal/archive/2012/11/21/retrieve-primary-entity-and-related-entity-data-using-odata-in-ms-crm-2011.aspx#.UgzO1CS3QdU

For Soap refer below blog. Using LinkEntity you can fetch both License plate and related account information in one Query.

http://mileyja.blogspot.in/2011/03/crm-2011-retrievemultiple-calls-in.html

Hope this helps!

Thanks!
- Edited by Kalim Khan Thursday, August 15, 2013 1:01 PM
- Proposed as answer by Kalim Khan Wednesday, August 21, 2013 11:04 AM
Thursday, August 15, 2013 1:01 PM

Asked by:

MS CRM 2011 ONLINE - Inheriting from lookup

Question

All replies