I have 2 linked tables, CLIENTS and APPOINTMENTS, where I link an APPOINTMENT record to a CLIENT record, and can have multiple APPOINTMENTS linked to a single CLIENT record.
Is there a way to sort the linked appointments in the client record?
For instance, could I pull the next upcoming appointment from that linked field and put it in a separate [Next Appointment] field?
Or, could I pull all past appointments to a [Client History] field?
Am I thinking about this the wrong way, completely?