Many times we require data from other entity being stored and referenced in source entity. i.e. Account Details in Opportunity.
We have Lookup relationship type for implementing the requirement, so lookup defines a way to get fields data from some Target entity to the source Entity
let see a simple scenario, we require to bring Financer to Opportunity (Financer is a type of Account with Type having value Technology Partner)
1. Setup- Objects - Fields ,click New
Select Lookup Relationship
2. Select the Target Entity, Since i need to fetch account details i will choose Account.
3. Provide Field Label and Description,
there are Option to make the Fields Required, by Ticking the Required Flag
and option for deleting the Relationship (clear the value or do not delete)
4. Now Comes the Important part, setting the Filter Criteria,
As mentioned in the beginning, i need to show Account in the Lookup, that have Type as Technology Partner.
Select the field in Account on which we need to Filter
Account:Type ,and in value choose Technology Partner from the Popup List.
Now when we see the Financer in the Form , we see only Records that match the Filter Criteria specified. Save and add field on the layout.
I will be covering some more complex scenarios in upcoming posts.