Skip to main content

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!

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.



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


Reply