Configure sugarcrm search with another table field

I would like to have a special search in sugarcrm: get all accounts that have events of a special type (for example, accounts that visit a client) Is this possible in sugarcrm? (I am using 6.2 CE)

Morever, I would like to force this special filter to be set for a group user (only the account that visited the client will see a special type of user)

Hi