Hey guys,

I have a bigggg problem and I hope you could help me (and I think there is no way of doing what I want!)

Well, baby steps:

Basically, we use 3 modules: Accounts, opportunies and contact.

Accounts we have a list of all companies, and some of them we don't have partnership.

In the module opportunities I have a field that tell's me if we've a partnership (now) with the company or not, like, in negotiation or closed.

What I want is to filter all the contact that are from accounts that have opportunities that are in negotiation!

An example:

I have 3 companies, X, Y and Z. The X has a opportunity which is closed, the Y is in negotiation and the Z doesn't have any opportunity.

I want to filter only the contact of the company Y, which is in negotiation!

Is it possible?? I accept any kind of modification! hahaha

Thanks a lot!