I have a Many-To-Many Relationship built out and I'm trying to compare two records. Each object has a Geolocation field and I want to calculate the distance between those two locations but I'm having trouble accessing the fields from the related records.
Is there a way to grab fields from many-to-many or does it have to be done through lookup-relationships?
#Sales Cloud #Salesforce #AwesomeAdmins #Data Management #Master Detail Relationship #Lookup Relationship
Michael Brown (Salesforce) 
Forum Ambassador
Hey Liz,
You may need to use a flow for this, but could elaborate on the objects in question.
If you're calculating this on the junction object that is relating these 2 objects, you may be able to retrieve the gelocation details from each object and calculate the distance on the junction record.
Thanks,
Mikey
