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,