Generate a report pulling data from multipule applications.

Generate a report pulling data from multipule applications.

Basically i have multipul applications
1) All Horses
2) Farrier
3) Vet work
I want to create a report where i can show all activities that the horses in "All Horses" have had completed. 

Thanks in Advance

JD