Page History
...
The report is based on patients, so you match fields that contain common data in both tables. Because both tables contain patient ID, you match the field containing the patient ID in the Patients table (patient_data.pid) with the patient ID field in the ADT table (adt_data.pid), as shown in the image below:
In database terminology, you are matching the primary key in one table (Patients) with a foreign key in the other table (ADT).
...
Overview
Content Tools
Activity