You can set the sort order on the relationship between the machinery to
descending date and it will grab the most recent record. To do this open
the relationship and select the sort in the bottom of the window.
President/CEO Fresh City & Souper Salad
Direct/FaceTime/Text - 781.223.8884
1 of 1 people found this helpful
Also note that if you don't want to change your existing relationships, you can add a new table occurrance for your report that has the sorted relationship.
If you just need the name of the person, you can also calculate a value in your materials table using the Last() function. IE Last ( Material_linkPerMat_PERSONNEL::name ) which will pull the value from the last related record.