Related tables and Queries

P

pfm721

I have a query that has 4 tables in it. When the query runs and the criteria
selected has information on all 4 tables it displays correctly. However for
instance if "999" is entered as the criteria in VetSSN, and tblVet has
information, but tblAppt does not because he doesn't have any appointment
information yet, the query does not display any of the information.
 
D

Dennis

Your joins on the tables are set to display records only where data in all
tables match. Click on the join lines between the tables and edit the join to
the applicable option for what you are trying to display.
 
Top