I have a quick question for you guys, it really looks like i'm drowning into a glass of water, but i'm not sure how to properly solve this.

I want to create a 1:1 relationship that is NOT an extension entity. Say, for example, i want to create a relationship from activity to opportunity, so that I can navigate like activity.Opportunity.Satus. Unfortunately i see no way of doing this using proper relationships without turning Opportunity an extension entity of activity, which makes no sense. A a possible workaround would be to create a calculated property in Activity called "Opportunity", which would do something like:

result = Sage.Platform.EntityFactory.GetById<Sage.Entity.Interfaces.IOpportunity>(activity.OpportunityId);

I'm wondering if there's an easier way of doing this. Creating calculated properties for each of my 1:1 (non extension) relationships looks like overkill.

Any ideas? I'd really appreciate your insight into this.

Can you not just make (in your example) the Opportunity a Many to One off Activity?

Well, i guess i could, then i would have activity.Opportunity on one side of the relationship and Opportunity.Activities on the other side. There should be an easier way of doing this, though. Sometimes you do legitimately need a 1:1 relationship which is not an extension.

Take a look at how the Account Manager and Owner properties are created from the Account (Contact or Opportunity).

In your case, if you think about it, from the Opportunity to the Activity, it is a One to Many relationship, because technically you could have multiple Activities pointing to it.

Mike's suggestion is the way to go.

Thanks for your kind replies. I'll follow your advice then