Results 1 to 2 of 2

Thread: relationship-specific custom fields (contact<->account)

  1. #1
    dbischoff is offline Member
    Join Date
    Sep 2007
    Posts
    6

    Default relationship-specific custom fields (contact<->account)

    My apologies if this has been answered, but I have not been able to find any.

    A contact can have a relationship with many accounts, but I can't find a way to add additional information to a unique one-to-one account_contact relationship.

    In other words, I may have a contact that works for multiple accounts, but has a different purpose in each of those accounts. I need to apply a specific designation to them in each of those accounts. To make it more complex, the same contact could be fullfilling multiple designations within a single account.

    If relationships could have custom fields the same way that modules do, I think it would all work. For example, if there was an accounts_contacts_cstm table.

    Can this be done, or will I have to create duplicate contacts and relate them to accounts on a one-to-one basis?

  2. #2
    ruchida's Avatar
    ruchida is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Feb 2005
    Location
    Japan
    Posts
    1,376

    Default Re: relationship-specific custom fields (contact<->account)

    Hi
    I think you need to re-design the accounts_contacts relationship because it can not have a custom field like a standard table. You need to make it an extended relationship class where each relation can have more properties (such as "purpose"). The good example is the opportunities_contacts relationship class which has a "contact_role" property allowing a single contact belong to multiple opportunities but act differently for each one.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. upgraded to 4.5.1e, received "Metadata for table tracker does not exist"
    By sfgeorge in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2007-09-03, 02:24 PM
  2. problemi step 6 di SugarSuite-Full-4.0.1h
    By lucia in forum Italiano
    Replies: 0
    Last Post: 2006-12-27, 08:50 AM
  3. Asterisk Patch 1.1.0 Crash on logon
    By skyracer in forum Help
    Replies: 6
    Last Post: 2006-07-08, 06:30 AM
  4. Replies: 7
    Last Post: 2006-06-06, 07:56 PM
  5. 4.0.1 Installation Problem
    By clawton in forum Help
    Replies: 14
    Last Post: 2006-02-13, 04:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •