Show multiple entry of the same product

I have 3 tables for Patient tracking. the 2 tables are referencing to table one. What I want is to have the to tables ( treatment and Appointment) show records of the same patient. The idea is to track the patients treatment and appointment. I want the records to be displayed in rows in the inline view.

Thank you in advance for any help

It’s clear from your screenshots that you’re already using references… not sure what’s the problem?

  • If you have a column in each of your tables that you want to “connect” to the patient table, and make this a Reference column type to the Patients table, you’ll find exactly what you’re wanting.
1 Like