I am using Sugarcrm for an insurance company. Here is how i have set-up my Sugarcrm(version 6.1.5 CE) :

  • accounts (considering switching to contacts) module filled with customers
  • 1 custom module named contracts with plain custom fields that simply store some numbers


with a many to many connection between them.

basically an account may have many contracts and a contracts may be linked to one or two customers.

what i want to do is have in the advanced search of accounts to have criteria based on the the contracts that those accounts have.

(If i understand sql correctly)In sql terms i'd like to have an advanced search that looks in the INNER JOIN of these 2 modules