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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

relating to the "latest" children

May 9, 200619 yr

I'm not sure where to post this question. I have three files; patients, lab dates, testresults. Each patient can have many lab dates which can in turn have many tests. They are related this way:

Patients

_kP_Patient ID

Lab Dates

_kP_LabDateID

_kF_PatientID

TestResults

_kP_TestResultID

_kF_LabDateID

I want "see" from Patients the last set of test results, that is, the testresults that would have the greatest labdateID for that patient and capture them in a value list. If I create in patients a calc field MaxLabDate = max (patients::LabDateID), I can't use this in a relationship bcs it doesn't index.

I remember back in FM5 days a technique that used the max function to "see" the latest set of records. Can't recall how it was done. I can't find any custom functions that seem to do the trick. Any ideas?