Query provides no result when related record is missing

[Phlee]

Hello,



I have a database with 4 tables that are linked with keys. I want to make a query where I can search an ID and gives me all the information from all the tables for that ID.

The problem is that not all ID's have records for all tables. I have found that my query only provides me a result if it has existing records for all tables. How can I make it so that it just gives me all available/existing information?

Can I do this without going into VBA?

Thanks.

[pbaldy]

You probably need to edit the join between the tables in the query. In design view, right click on the join line to edit it.