Using the field of a connected connected record

Hi all,

I have three record types Contacts, Appointments and Contracts. Contacts are connected to many Appointments and many Contracts.

In my Contracts table, I’d like to display the Date/Time of one of the Appointments connected to the Contact connected to the Contract.

The problem is I have two Appointments connected to each Contact. A Sales Appointment and an Install Appointment.

Does anyone have any thoughts on how to do this or if it’s possible?

My current workaround is have a connection between Contracts and Appointments but this feels unnecessary and makes the system more clunky.

Thanks in advance,