Skip to main content
Topics#Data ManagementRick Stevenson's Question
Rick Stevenson (CareMore Health Plans) asked in #Data Management
Jul 1, 2012, 12:19 AM

How do you get Field2 values from a table based on Field1 relationships

In Microsoft Access you can use a Parent-Child relationship to associate two tables based on a common field, then use that association to pull the values of othere fields from the Child table.  In SQL you can do the same thing.  It doesn't appear to be possible to do this with Salesforce - without using the services of an APEX programmer.  Is this really the case or have I just not looked at the right instructions?

 

In this case we'd like the user to vlookup a location and have a series of additional fields on the form populated automatically from the source table, based on the users selection in the location field.

 

Thank you,

 

Rick Stevenson
3 answers
  1. Ashish Yadav (Evoke Technologies)
    Jul 1, 2012, 7:11 AM

    If you have Master -detail that is Parent child relationship .. you can use roll up summary to display values on you detail page...

    Thats also an option that can be considered 

Write an answer...
0/9000