I have three custom objects: Entity, Residency, and Address. Entity and Address have a many-to-many relationship; Residency is the junction object (two master-detail relationships.).
Is it possible to access fields on a related Address object from an Entity object? For example, to implement a formula field on Entity which automatically finds the Current Address based on Address move-in date. Or to show one or more objects from the Residency related list (which contains columns from Address objects) in a Visualforce page with standardController="Entity"?
I've used Apex to look at the fields on Entity objects, and Residency__r is not one of them. What are some work-arounds to access data in both directions in a double master-detail relationship? Should I instead create a many-to-many relationship using lookups?
Thanks!