Lookup fields in CRM 2011

Question

Entity Application has a look up to Contact. Now, Entity Application Document has a look up to Application. In my Application Document form, I want to display the Contact who is associated with the Application Document. I do not want to be creating a look up to Contact as it is just bad database design.

How can I show the related contact in the Application Document form. It is after all a look up - alright, a two level look up right? I can go from the Application Document to the Application to which it is related and from there to the Contact.

My suggested solution would be to have a read only text field in the Application Document entity. Populate it with Contact (Primary Field) onloadform with a JavaScript.

What is Application Document. I'm not clear on the question, to be frank. Are you trying to refer to a field on a form of a look up entity of an other lookup entity? — Konrad Viltersten
Yes, on the form of Application Document alongside Application (a lookup), I want to display the Contact (which is a lookup on Application). — Kanini

Konrad Viltersten Konrad Viltersten · Accepted Answer · 2013-03-04T18:24:38

I'd resolve it as a call to the DB, fetching the linked entity and then fetch it's linked entity. JavaScript seems to be the wises choice in this case.

However, you mention that you find this solution bad, so I might be missing a requirement.

Lookup fields in CRM 2011

1 Answers