I’m not sure I’m following your description, but here’s my best attempt:
- AppointmentID (autogenerated by formula)
- Start Time (date field with time turned on)
- back link to Client
From here, add to the Client table a Lookup field that pulls in the “Start Time” column from the linked Appointment record. Then you should be able to sort by that lookup column.