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.

need a caculation to get info from a specific related record

ggh
in Calculation Engine (Define Fields)

Featured Replies

I'm working on a school database with several tables: students, classes, class_records. Students has general demographic information, classes is a list of classrooms and grade levels, class_records is the table where kids are assigned to classes.

Class has:

grade

teacher

year

room

Class_records has the following fields:

recordID

studentID

classID

year

What I need to do is create a calculation field in the student table that shows the grade level for the most recent year.

I'm sure this is simple, but I'm drawing a blank!

Try Last(class:grade)

Hope that helps

  • 2 weeks later...
  • Author

Last(class::grade) did the trick with a little more work on relationships. Thanks!

Create an account or sign in to comment

https://fmforums.com/topic/46071-need-a-caculation-to-get-info-from-a-specific-related-record/
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.