--- title: Relate Records Based on Matching Field Values | Lookup Helper Use Case Library description: When data is being loaded into Salesforce from an external database, it is very difficult to maintain the relationships that existed previously. --- [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779 [![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com) - Solutions - By User Type - [Admins](https://www.passagetechnology.com/en/solutions/salesforce-admin) - [Getting Around Rollup Limitations](https://www.passagetechnology.com/en/solutions/salesforce-admin#rollup-limitations) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-admin#Reports) - [GDPR Compliance](https://www.passagetechnology.com/en/solutions/salesforce-admin#GDPR) - [Data Cleanup](https://www.passagetechnology.com/en/solutions/salesforce-admin#cleanup) - [Project Managers](https://www.passagetechnology.com/en/solutions/salesforce-project-managers) - [Managing Internal Projects](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#internal-projects) - [Collaborate on External Projects & Client Status Reporting](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#External) - [Project Analytics](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#Analytics) - [Salesforce Training for Project Management Success](https://www.passagetechnology.com/en/solutions/salesforce-project-managers#SF-training) - [C-Suite](https://www.passagetechnology.com/en/solutions/c-suite) - [Business Insights](https://www.passagetechnology.com/en/solutions/c-suite#business-insights) - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/c-suite#decision-making) - [Project Planning & Managing Execution](https://www.passagetechnology.com/en/solutions/c-suite#managing-execution) - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/c-suite#custom-solutions) - [IT Managers](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce) - [Security & Compliance](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#security) - [Enabling Salesforce Users](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#enabling-team-members) - [Managing IT Projects](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#projects) - [Avoiding Technical Debt](https://www.passagetechnology.com/en/solutions/it-managers-using-salesforce#avoid-technical-debt) - [Salesforce Analysts](https://www.passagetechnology.com/en/solutions/salesforce-analysts) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/salesforce-analysts#reports) - [Project Management](https://www.passagetechnology.com/en/solutions/salesforce-analysts#project-management) - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/salesforce-analysts#custom-solutions) - By Industry or Cloud - [Software](https://www.passagetechnology.com/en/solutions/computer-software-industry) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/computer-software-industry#reports) - [Decision Making & Prioritizing Initiatives](https://www.passagetechnology.com/en/solutions/computer-software-industry#decision-making) - [Project Management](https://www.passagetechnology.com/en/solutions/computer-software-industry#project-management) - [Security & Compliance](https://www.passagetechnology.com/en/solutions/computer-software-industry#security) - [Healthcare & Life Sciences](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud) - [Project Management](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#project-management) - [HIPAA Compliance](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#hipaa) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#reports) - [Custom Solutions & Integrations](https://www.passagetechnology.com/en/solutions/healthcare-life-sciences-industry-cloud#custom-solutions) - [Financial Services](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud) - [Relating Custom Objects](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#custom-objects) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Reports) - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#data-quality) - [Compliance](https://www.passagetechnology.com/en/solutions/financial-services-industry-cloud#Compliance) - [Nonprofit](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud) - [Reports & Data Aggregation](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#reports) - [Improving Data Quality](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#data-quality) - [Project Management](https://www.passagetechnology.com/en/solutions/nonprofit-industry-cloud#project-management) - Products - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview) - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview) - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview) - [Work Trail](https://www.passagetechnology.com/work-trail-overview) - [Support](https://www.passagetechnology.com/support) - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-training) - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-training) - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-training) - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-training) - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-training) - [Work Trail](https://www.passagetechnology.com/work-trail-training) - [Services](https://www.passagetechnology.com/developmentservices) - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/) - [Log a Support Case](https://www.passagetechnology.com/contact-us) - [Resources](https://www.passagetechnology.com/resources) - [Blog](https://www.passagetechnology.com/passage-technology-blog) - [Customer Success Stories](https://www.passagetechnology.com/customer-success) - [Essential Guides for Business Transformation with Salesforce](https://www.passagetechnology.com/en/essential-guides-for-business-transformation-with-salesforce) - [Use Case Libraries](https://www.passagetechnology.com/use-case-libraries) - [Knowledge Articles](https://passagetech.my.site.com/KnowledgeBase/s/) - [Release Notes](https://www.passagetechnology.com/release-notes) - [Company](https://www.passagetechnology.com/about) - [About Us](https://www.passagetechnology.com/about) - [Press & Testimonials](https://www.passagetechnology.com/press-testimonials) - [Contact Us](https://www.passagetechnology.com/contact-us) - [Partners](https://www.passagetechnology.com/partners) - [Careers](https://www.passagetechnology.com/working-at-passage) - [Search](https://www.passagetechnology.com/search) # Relate Records Based on Matching Field Values [![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers) ## Problem: When data is being loaded into Salesforce from an external database, it's difficult to maintain the relationships that existed previously. With Lookup Helper, you no longer have to spend hours updating lookup fields, or have to hire a developer to write custom code that will maintain the relationships. ## Solution: Here's a solution that can help you achieve this: 1. Create two fields on the child record. 1. - The first field will hold the ID of its parent record. - The second field will be a lookup field relating to the parent object. 2. Create field on the parent record that will hold its old ID (used in the external database). 3. Create a new Lookup Helper setting. 1. Select the child object. 2. Select the 'Maintain existing lookup field' option then select the lookup field to populate (second field created in step 1). 3. Select the 'Relate child object when the value in a field matches the value in a field on the parent object' Lookup Helper setting type. 4. Select the first field created in step 1 for the child object. 5. Select the field created in step 2 for the parent object. 6. Save and run the setting. [Lookup Helper Use Case Library](https://www.passagetechnology.com/lookup-helper-use-cases) | [** Top Use Case: View Account Information on a Lead ](https://www.passagetechnology.com/lookup-helper-use-cases/display-account-info-on-leads) | [Lookup Helper Use Case Library](https://www.passagetechnology.com/lookup-helper-use-cases) | [ Set Up Lookup Fields to Trigger Emails in Salesforce ** ](https://www.passagetechnology.com/lookup-helper-use-cases/better-utilizing-your-marketing-automation-tool) | | --- | --- | --- | [ Tracking Open Cases on Contacts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/track-open-cases-on-contacts-in-salesforce) [ Tracking Open Cases on Accounts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/track-open-cases-on-accounts-in-salesforce) [ Relate Contacts to their Assistants in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/relate-contacts-to-their-assistants-in-salesforce) [ Automatically Link Contacts to Individuals in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/automatically-link-contacts-to-individuals-in-salesforce) [ Automatically Link Contacts to Account Owners in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/automatically-link-contacts-to-account-owners-in-salesforce) [ Link Child Accounts to Ultimate Parent Account in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/ultimate-parent-account) [ Set Queue Custom Object on Any Standard Object ](https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-set-queue-custom-object-on-any-standard-object) [ Display Related List of Grandchild Records on the Parent Record ](https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-link-cases-and-opportunities-to-parent-accounts) [ Relating Cases to Accounts in Salesforce ](https://www.passagetechnology.com/lookup-helper-use-cases/relating-cases-to-accounts-in-salesforce) [ Assign Lead to Account Owner and Send New Lead Notification ](https://www.passagetechnology.com/lookup-helper-use-cases/assign-lead-to-account-owner-and-send-new-lead-notification) ![Salesforce certified services by trusted Passage Technology](https://www.passagetechnology.com/hubfs/Salesforce/SF%20Partner%20Badges%202026%20(for%20footer).png) Explore - [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) - [Milestones PM+](https://www.passagetechnology.com/milestones-pm-plus-overview) - [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) - [Prioritization Helper](https://www.passagetechnology.com/prioritization-helper-overview) - [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview) - [Work Trail](https://www.passagetechnology.com/work-trail-overview) Services - [Custom Development Services](https://www.passagetechnology.com/developmentservices) - [Milestones PM+ Starter Packs](https://www.passagetechnology.com/milestones-pmplus-starter-packs) Learn - [Support Portal](https://www.passagetechnology.com/support) - [Resources Portal](https://www.passagetechnology.com/resources) Company - [About](https://www.passagetechnology.com/about) - [Careers](https://www.passagetechnology.com/working-at-passage) - [Press & Testimonials](https://www.passagetechnology.com/press-testimonials) - [Partners](https://www.passagetechnology.com/partners) Questions? - [Contact Us](https://www.passagetechnology.com/contact-us) - +1 (224) 655-6779 [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) © 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496) - [** ](https://www.facebook.com/passagetech) - - [** ](https://www.linkedin.com/company/passage-technology) - [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Shawn Hepker", "url" : "https://www.passagetechnology.com/lookup-helper-use-cases/author/shawn-hepker" }, "dateModified" : "2026-07-30T18:40:12.922Z", "datePublished" : "2015-05-14T13:07:59.000Z", "headline" : "Relate Records Based on Matching Field Values", "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/lookup-helper-use-cases/top-use-case-relate-records-based-on-matching-field-values", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png" }, "name" : "Passage Technology LLC" } } ```