Results 1 to 2 of 2

Thread: relationships with attributes

  1. #1
    ita_k is offline Junior Member
    Join Date
    Jun 2011
    Posts
    1

    Default relationships with attributes

    Is there an easy way to add attributes to relationships in 6.2.0 ?
    Scenario:
    Step 1:
    I have 'Products' module with many-to-many relationship to accounts, I would like to know all the products a specific account bought and all the accounts that bought a specific product.
    That can be easily achieved with many-to-many.
    Step 2:
    Now I would like to know how much each account payed for each product, so:
    I would like to know all the products a specific account bought and how much they payed for each one and all the accounts that bought a specific product and how much each account payed.

    I saw some tutorials about adding a middle module with many-to-one relationship between 'products' and 'accounts',
    If someone can explain how to achieve that in 6.2.0 (or another solution) It'll be highly appreciated.

    Thanks,
    Ita.

  2. #2
    kbrill's Avatar
    kbrill is offline SugarCRM PS Engineer
    Join Date
    Jul 2004
    Location
    St Louis, MO
    Posts
    3,183

    Default Re: relationships with attributes

    I havnt done all the research needed for this but I dont see that a middle module is needed. Each product that is quoted is added to the Products module (they come FROM the ProductTemplates module) with a relationship to the account. You should be able to add some custom fields there to fill out that have the info you need and then you can report on it.
    Kenneth Brill - Help Forum Moderator

    I do not respond to 'Private Messages'. Please email me directly instead

    When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
    Help us Help You

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can relationships have attributes/fields?
    By davideps in forum General Discussion
    Replies: 5
    Last Post: 2011-05-16, 07:11 PM
  2. Replies: 2
    Last Post: 2010-03-25, 09:39 AM
  3. Relationship attributes
    By alexhoffmann in forum Help
    Replies: 0
    Last Post: 2009-12-15, 05:26 PM
  4. How do I add more attributes to a SOAP API?
    By clearwater in forum Help
    Replies: 1
    Last Post: 2007-11-25, 04:07 AM
  5. Attributes for contacts?
    By pschuster in forum Feature Requests
    Replies: 1
    Last Post: 2006-03-01, 04:36 PM

Tags for this Thread

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
  •