Community
Showing results for 
Search instead for 
Do you mean 
Reply

link between opportunity and product

Copper Contributor
Posts: 84
Country: Singapore

link between opportunity and product

Hi All ,

 

I have manage to access opportunity table from ACT using Qlik View software.

 

The problem i encounter is i am not able to link up both table

 

 

below is group opportunity table 

 

SQL SELECT *
FROM "Master_TDS".dbo."VRP_GROUP_OPPORTUNITY";

 

below is Opportunity product Table :- 

 

SQL SELECT *
FROM "Master_TDS".dbo."VRP_OPPORTUNITY_PRODUCT";
 

 

Hope some one can advise me.

 

Paul Yeo

 

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: link between opportunity and product

One tip that very few people seem to know... have a look in the folder: C:\Program Files\ACT\Act for Windows

 

You should find a file that might be useful to you - ACTDataDictionaryDocument.rtf

Copper Contributor
Posts: 84
Country: Singapore

Re: link between opportunity and product

Hi Mike,

 

Thank you , i will take a look of the doc file. hope that i can find the solution. 

 

Paul Yeo