Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Counting related child

Featured Replies

I have a report that is created off of 2 files related by the job_no contained in each file. The application is for tracking repairs. The main file is job_hdr and the child is job_items. The report is created in the job_items file and is sorted by job_id. I cannot get a summary field to show me the count of jobs on this report. I need to know in which file to create the summary field.

This is a picture of the report if it helps in my lack of description.

fm1.jpg

The number 92 in the image below should be 2 but it is counting the total of customers in the header, not the found count of customers.

fm2.jpg

  • Newbies

It looks like you ... might ... be mixing two different versions of count. The summary field count has NOTHING to do with relationships. It is used to return a count of non empty fields in the current field ... and ... in the case of subsummaries when sorted by a break field.

The COUNT function is how you count non-empty related fields. So if you have a record that is related to 6 child records. You can count the number of related records that have a value in a particular field.

You can Summarize a calculation field that has a COUNT function in it. However, I don't think you need to if I'm reading your post correctly.

FYI ... shameless plug ... we sell a 100 page 40+ examples guide to FileMaker calculations and functions. It's only $16.00, so it's cheaper than a large pizza and might help you out. You can find it at www.buyfmprostuff.com.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.