Creating a two table Query that is linked and show all data from one table and linked data from second table.
Posted on 2008-06-24
I have created a database for tracking medical visits to a first aid center on a project site. The database has a few tables that are linked to make the database more user friendly because it pulls data from different locations to autofill fields when someone comes to the first aid center for a consultation. The problem I have is this:
I have a Query that has two tables. Table one is "Patient Information" and Table two is "Daily Consultation." When I created the query I linked two fields "Project ID Number" from the patient information table and "Compnay Project ID Number" from the Daily Consultation table. I used the Join Properties to link the two fields. I also selected the third radial button so that (in theory) all records from the Patient Information table would appear and any Daily Consultation data would appear that was linked to a patient (all data is linked, so all data from both tables should appear). The problem is that only the data from the Daily Consultation appears when the query is opened.
The reason I need the data from both tables is that if it is a new patient (never had a consultation), then when you select the patient I can auto fill the daily consultation with information from his or her information located in the Patient Information table. If it is a patient that has a history of consultations, I pull the last record and copy selected data from that consultation and autofill the fields in a new consultation.
Any suggestion on how to get get the data from both tables to appear would be appreciated.