I have a parent and child relationship table set-up which we use to track Employee Trainings. The first table, Employee Trainings (Parent), lists all of the trainings people have to take. From each training, personnel in our office will create a record (an attestation) in our Attestations table (Child) to attest to the specific training records.
Some of the trainings need to be completed annually. Is there a way to capture the most recent attestation for each training by personnel?
I have used the guidance below, but when I do this the Maximum Record ID brings in the latest attestation, regardless of who completed it. I do not see a way to filter my summary field to have it unique by user.
Please note - I could do this by "Current User" option, but that doesn't work when I need to see someone's information.
Guidance I have already found, but doesn't appear to get me all the way to my answer.
(From Mark Shnier in another post)
Make a summary field of the maximum of the Record ID# of the child status table records called [Maximum Record ID# of status records]
Make a new relationship where 1 Status is related to Many parents - ie a reverse relationship and the reference field at the right side will be that field [Maximum Record ID# of status records]
Then just do a lookup of the Status from the Child to the Parent. but QuickBase will see it as a lookup from a parent to a child.