Hi @Dilon,
Thanks a lot for your help.
By some trial and error, I managed to get it working somehow.
(I believe my confusion essentially stemmed from my inability to decide which exact fields should act as foreign keys between
the three tables and how to name these foreign key fields.)
(1) logged in caregiver patients list → (2) patient details
→ (3) Patient medications list → (4) Patient medication details
(1)
(2)
(3)
(4)
Thanks for your help.
Kâmi