adding a count of activities with a customer

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have a simple app and I am looking to have report with each customer identify the number of activies recorded with the particular customer. The customer and activities are on different tabs. Any help would be appreciated. I am a beginner QB. 
Photo of Bryan

Bryan

  • 40 Points

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,988 Points 1k badge 2x thumb
Go into one of the tables (tabs) and click settings. Then click relationships. You should see one connecting Customers to Activities. On the Customers side you want to click Create Summary field. Additionally you can enter a criteria to filter that number if you're looking for a specific type of activity count. 

Now that you have the field created you can go to the Customers table, click reports and charts and create a new one. Choose the customs you want to see, maybe Name, Address, Phone, # of Activities for example.

Hope this helps! Good luck!