I work at a public mental health service and we use airtable to coordinate our work.
I have a patients table linked to a visits table, which in turn is linked to a prescription table, which is finally linked to a drug table.
I want to be able to retrieve the last drug a patient has received in the visits table. How could I go about doing that?
Thanks in advance!