Community
Showing results for 
Search instead for 
Do you mean 
Reply

Two Tables Withe The Same Name

Silver Elite Contributor
Posts: 3,311
Country: United_Kingdom

Two Tables Withe The Same Name

Anyone know why, when you run a Table RecordCounts report form ACTDIAG it finds two tables with exactly the same name?

Tried a few databses including ACT11Demo - same thing.

 

ENTITY: Opportunity
  Table Displayname                 Records            Table Physicalname
  --------------------------------  -----------------  --------------------------------
  Opportunity                       352                TBL_OPPORTUNITY
  Company Opportunity               26                 TBL_COMPANY_OPPORTUNITY
  Contact Opportunity               357                TBL_CONTACT_OPPORTUNITY
  Group Opportunity                 0                  TBL_GROUP_OPPORTUNITY
  Opportunity Activity              0                  TBL_OPPORTUNITY_ACTIVITY
  Opportunity History               1034               TBL_OPPORTUNITY_HISTORY
  Opportunity Note                  0                  TBL_OPPORTUNITY_NOTE
  Opportunity Product               678                TBL_OPPORTUNITY_PRODUCT    <<<<<<<
  Opportunity Product               613                TBL_OPPORTUNITY_PRODUCT    <<<<<<<

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Moderator
Posts: 4,395
Country: USA

Re: Two Tables Withe The Same Name

Not sure why the report is showing tables with the same name.  I can only see one TBL_OPPORTUNITY_PRODUCT through SQL Management Studio and the first listing shows the correct amount of records.  So in your cases its 678.
Silver Elite Contributor
Posts: 3,311
Country: United_Kingdom

Re: Two Tables With The Same Name

David

 

What do you see if you run the Table RecordCounts report form ACTDIAG?

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Moderator
Posts: 4,395
Country: USA

Re: Two Tables With The Same Name

I see two as well.
Tuned Listener
Posts: 17
Country: Australia

Re: Two Tables Withe The Same Name

This is issue has been forwarded to the development team, I will update you here when I have more information.

 

Thanks,

 

Kurt