Hello!
I have 3 modules connected to each other:
Agents
Doctors
Patients
Each Doctor has a (unique) related agent; each Patient has a (unique) related Doctor.
Fig. a - Doctor Module
Doctor module with related AgentFig. b - Patient Module
Patient module with related doctor
On the Doctors module, I can see ALL the patients connected to them. At the same time, on the Agents module, I can see ALL the doctors connected to them.
I'd like to create a Related List also between the Agents and the Patients. I can create a list using the reports, but Id' like to create function that returns the related list between Agents and Patients.
Fig. c - Agent Module view
I looked around the website and community too, but I really don't know where to start!
Can anybody help me?