I am trying to create a call log for our company, but the issue is that I want to figure out how to display multiple back and forth or escalations relating to one call case without adding many rows.
I think this could be done with linked records. but here is the schema:
Last Name
First Name
ID
Date
Type
Relation
Reason
Description
Phone
Email
Link to Assigned Staff / Assigned Team for follow-up.
Status (for follow-up) with Resolved or Escalated.
I want to demonstrate if it is Escalated that it would move to another person, and allow them to do the next level of response.
Or to have multiple entries documenting communication attempts at various levels before Resolved
Does that make sense? Feels like I need a sophisticated Junction Table
