You need to sign in to do that
Don't have an account?
Stephen Elkind
I am looking to have a cross-join (I think) query displayed on the Accounts Page. Help?
I have a SQL and MSAcess background. Specifically, we have setup our Enterprise edition with Accounts, Opportunities and Projects. An account can have multiple opportunities. A Project can have multiple opportunities (each linked to an account). However, a Project can also have multiple opportunities for multiple accounts. Hence, If I were to pull up an Account, I should be able to have a VIEW that shows all of the distinct Projects that have Opportunities linked to this Account. This would be the "Related Projects" to an Account as determined through the Account/Opportunity relationship.
With the One-Many relationship and Lookup Relationship, I can have related lists on the Account Screen. Is there a way to show the "Related Projects" in a Related List format on the Accounts Page?
With the One-Many relationship and Lookup Relationship, I can have related lists on the Account Screen. Is there a way to show the "Related Projects" in a Related List format on the Accounts Page?