Report of multiple different tables arranged by date
I have a filemaker pro 12 database for a veterinary clinic.
Each client has multiple animals, each animal has multiple visits, prescriptions, communications.
For each animal, I would like to create a report or list that can be saved as a PDF to show all items from all of these tables, but arrange them by date so they are in the order each happened. Is there a way to do this?