adding a count of activities with a customer

  • 0
  • 1
  • Question
  • Updated 1 year 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 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 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!