1 Reply Latest reply on Jan 27, 2017 1:45 AM by Johan Hedman

    Correspondence Log

    sherab4

      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.

        • 1. Re: Correspondence Log
          Johan Hedman

          If you have following tables

           

          Students

          Teachers

          Letters

           

          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.