creating a running comments/contact field
I am trying to create a part to my database where our tutors can write out the type of contact they have had with our students/contactees.
It would be a weekly contact and I would need to keep the contents of that contact as well as have it accessible for later documentation. I would need to be able to attach a date, contact codes, the tutor's initials and lines of text for individualized comments.
Visually it would look like:
DATE (of contact) | CONTACT CODE # | TUTOR INITIALS | COMMENTS
Any hints or help is greatly appreciated.
Place your records in a related table by StudentID and then use a portal to display the results on a layout based on your student information table.