Query on tables with null values

[L'apprentis]

Hi,
I have a problem with one of my query, the query has 2 tables, the secondary field from Table2 is linked to the primary field of table1.
The primary field Doesn't allow null Value
The Secondary Field does allow null value which means that the Data in table 1 only concern Some of Table2's Data.
If I run the query with the two tables I can only see the records with the secondary field with no Null Value.
Is it possible to get the query Showing All the records of table1 2 and Table1 even if Table1 has no values?

 

[Sammy B]

Look at the join in your query. If it does not have an arrow on one end then you have the wrong one. Right click on the join and choose edit.

Sam