Changes

Jump to: navigation, search

Reports Based on Multiple Tables - Overview

768 bytes added, 16:05, 8 July 2019
no edit summary
:: [[File:Recordsets tab.png|750px|border]] 
37. Scroll to Set the primary table to '''TablePrimary Table ''' listto '''Organizations '''and the '''Inner Join '''as '''Contacts.'''
4. Set the primary table to To do so, simply set both the '''Organizations '''field (found under the '''Companies/AccountsCompany and Account '''heading) and the '''Contacts '''field (under '''Users and Contact) '''to '''Inner Join: '''.
:: [[ImageFile:Reps99Company and contact inner join.png|250px|border]] 
5* The '''Organizations '''recordset will report on company information that you have entered into the system, including all organization-specific [[Custom Fields]] that are related to organizations. Set the * The '''Contacts '''recordset will report on all contacts 'Contact'outside '' of your organization (although this does not automatically mean that they are [[External|}external]] [[User|users]]). This table as an will include all contact-specific and [[User Role|role]]-based [[Custom Fields]].  8. Scroll down to the bottom of hte page and click '''Inner JoinSave.'''.
=Inner and Outer Joins=
2,299
edits

Navigation menu