Sorting by Linked record date

[Michael_Novell1]

I have related tables with clients and appointments. the appointments are dates that are selected via linked record in the client table. I need to be able to sort by date in the client table, but it is not working. I have tried to create a formula field with the related date being parsed but it still does not sort by that. Please help!

[Nathaniel_Grano]

I’m not sure I’m following your description, but here’s my best attempt:

Client Table

• Name
• link to Appointment

Appointment Table

• 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.

[Michael_Novell1]

Thanks for posting this solution. I think it is working!!