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.

How to create portal Subsummaries for found sets

Ben Parkin
in Portals

Featured Replies

  • Newbies

I have got stuck with my database and need some advice.

My database is for a charity which does school presentations. School bookings are taken for a given date, particular school and a selection of presenters do the talk.

I have set up a demo with the many-to-many relationships and portals in the booking layout. Subsummary Demo file.fp7.zip

I need to generate end of term reports with summaries of team activity. Therefore the layout includes summary data from the bookings table, schools table and presenters table, and I have put fields on a subsumary part by term. I have given the specific info needed in the demo. e.g if schools or presenters do more than one booking, I only want to list them once.

Can I get summary fields in portals for this? When I try this, it gives portal info for one booking and not for all bookings in the given term.

Would really appreciate any advice.

Create an account or sign in to comment

https://fmforums.com/topic/86427-how-to-create-portal-subsummaries-for-found-sets/
Go to topic listing

Important Information

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

I accept

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.