Skip to main content

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

Be the first to reply!

Reply