Skip Navigation LinksHome > Categories > Code from a Category

ZOHO CRM: How to use lookup field

User Name: jamest85
Name: James Tang
Contact Me:
Home Page:
Google Apps for Work Partner, Certified Zoho CRM Consultant. 7 years experience on Zoho consulting, implementation, and programming using C#, VB, Php..., 15 years of total IT experience including prog... [More]
Viewed Times: 5393
Add Date: 03/18/2010
This post shows how to use the "lookup field" in most of Zoho CRM modules such as Leads, Contacts, Accounts. If use wisely, this control can become a very nice feature.
As we all understand that if we use any existing database application, it won't 100% fit your current business module, sometime needs make extra steps to reach your goal, sometime just impossible, same as Zoho CRM.
But I think the Lookup filed is very useful control allows us passing information between modules. For example: In Contact, we need a referral information which including 2 fields:
1. Who referred to you?

2. Referred customers

That means a new contact can be referred by another existing contact, but also later on, that new contact might referral other customers. We need all those contacts recorded

Here is what to do:

Once above Lookup field is created, the "Related List: Referred Customer" field will be automatically shown in each Contact's detail list.

After done that, if, for example, John is referred by Bob, in John's "Referred By" field will have Bob's name, and in Bob's contact form, John will be listed in Bob's details section=> Referred Customers, if Bob referred another 10 contacts, will be also listed in his details section.

This Lookup field can also look-up to different modules.

The relationship of those two fields are based on many-to-one table relationships.

Post a Comment

Name: (Optional)
Email: (Optional, you can get an email if somebody replys your comments)*
Email me if somebody respons my comment below:
Enter Text
as Below:
(case insensitive, if hard to read, click the "get a new one" button)
* Your email address will not be shared with any third parties for any reason.
** Maximum 1000 charactors.