I have two custom modules: Systems and Contracts
Systems have a relationship to an Account
Contracts have a relationship to a System
I always want to be able to see the associated Account for that Contract (through the System).
I have a field:
System :: (Lookup Field, Lookup Type = "System") // System is the custom submodule that has a Lookup Field field "Account"
I want another field that retrieves the Account from the System record and provides that as a link.
Is a second order lookup such as this a possibility?