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!
Page 1 / 1
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.