I have a correspondence log that list all letters from Students and from Teachers. I want to show in separate fields on a report page showing "First Letter from Student", "First Letter from Teacher", "Last Letter from Student", "Last Letter from Teacher". Also how long it has been since the last letter was receive by the student and replied by the teacher.
Any help on how to set this up and create the fields to show this info would be greatly appreciated.
If you have following tables
And you have a field Category in Letter that gives you all the different variants of Letter you can have then you can build a relationship from Teachers and Students to Letters and have related data show just the Category you want.