Community
Showing results for 
Search instead for 
Do you mean 
Reply

Queries/Lookups Join Type

Copper Contributor
Posts: 60
Country: United States

Queries/Lookups Join Type

Hi,

 

I am trying to create a dynamic group with several constraints. The lookup that is generated seems to be an INNER JOIN versus a LEFT OUTER JOIN or a FULL JOIN. I can say this because the lookup is missing many records that meet the specified criteria. We have several custom fields and I think we have a custom overflow table. I am not able to figure out how to force ACT to perform a LEFT OUTER JOIN with the custom table.

 

We are using ACT! by Sage Premium 2010 Version 12.0.409.0, Hotfix 3. Our database has about 14000 records.

 

Additional Info - This worked correctly in the previous versions of ACT (ACT 2009/ 2008). If I click to create a lookup on any of the dynamic groups created with previous versions of ACT the list of records generated is accurate. But if I click to edit criteria in ACT 2010, the search criteria is somehow modified in the backend and the results shown are incorrect again.

 

Any suggestions/thoughts on what might be happening here?

 

Thanks,

Sudha