Help with the Opportunities-Contacts relationship

[shanrocks]

I hope someone out there can give me a hand with this. I'm working with Sugar 5.0 RC, but this is probably applicable to 4.5.1 as well. I've also been working with both Linux and Windows platforms, but I don't think that is relevant.

I'm developing a couple of modules that have a relationship similar to the one found between Opportunities and Contacts. That is, the relationship itself has an additional field. In the case of Opportunties and Contacts, that field is the role of the Contact in the Opportunity.

I'm pretty sure I've set up my own relationship correctly - the correct information appears to be saved in the appropriate table in the database, so that is all good. The problem I am currently having deals with displaying the value in the subpanel.

I can't find the place where this value is retrieved from the database. I find some field definitions in Contacts (opportunity_role_fields, opportunity_role_id, opportunity_role) and the same fields listed in the ForOpportunities subpanel definition. I have no idea how or where these fields are populated.

Also, I see that the Opportunity class file (Opportunity.php) has a function named get_contacts. It looks like this would pull out some relevant information... but when I modify the function to output to the log when this function is called, I never see it. When does get_contacts get called? Or is this just old code?

If anyone has any experience with this type of development, I would really appreciate the assistance.

Thanks!

[mclemmens]

Yes, I'm trying to do this as well. From what I've found so far, it's very difficult to customize the system. There was talk a long time ago (starting around version 3) to make a B2C as well as B2B mode, but that never materialized.

If I find anything I'll post it here.

Best,
Mac