Community
Showing results for 
Search instead for 
Do you mean 
Reply

Create Contact Lookup From Company Lookup

New Member
Posts: 7
Country: USA

Create Contact Lookup From Company Lookup

Is there anyway that I can create a contact lookup based on the data in a business's entry? For example, I might want to create a lookup of all of my contacts whose company has more than 10 employees.

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Create Contact Lookup From Company Lookup

This is not something that you will be able to do with a simple lookup.

 

1) Act! does not have a built in facility to list all contacts based upon a lookup against companies.

 

2) Your example requires math ("How many contacts are there for each company?") and thus will require SQL to pull off...

 

If you know SQL at all, you might be able to pull off what you want using the Act! 2010 Data chart component in a custom dashboard...

 

Another option might be using something like Stonefield Query...