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.

Finding all related records (and more)

jugglingdan
in Finding & Searching

Featured Replies

  • Newbies

Apologies if this question is in the wrong place... I'm new to the site and this seemed the most appropriate forum.

I have created a database with a table of 'pupils' and a table of 'payments' that pupils have made. I have defined a relationship between the tables. I have created a field called 'ID' in both tables.

I want to have a field in my 'pupils' table that shows the total amount paid. I think the structure should be something like this:

1. Go to to 'payments' table

2. Find all records with 'ID' field value matching that of the 'ID' field value of the current record in the 'pupils' table

3. Take the value of the 'amount' field in each of those records and add together.

4. Return this calculated value to the 'total' field in the 'pupils' table.

My problem is that, being a beginner, I don't know how to implement this. Can anyone help? Thanks in advance.

  • Author
  • Newbies

Ah! Worked it out! I just defined my 'total' field as a calculation and stuck in Sum (Payment::amount). Thanks anyway.

Create an account or sign in to comment

https://fmforums.com/topic/39627-finding-all-related-records-and-more/
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.