Query not seeing 'blank' table

[Raven]

I have a dbase which consists of three tables all linked.

I have created a query which pulls various fields from each of these tables.

tblobjective
tbltask
tbldates

On some occasions there may not be any data in the tbldates, but there could be in tblobjectives and tbltasks.

My query doesn't seem to pull the record if there is no data in tbldates. I've even tried setting the default value of a field in tbldates so there is always some data, this works fine and puts a date in, but the query still won't pull until I manually enter a date.

Sorry if this isn't a very clear explanation, hope someone can help!

 

[Mile-O]

What sort of joins are connecting your tables?

On the query design grid, right click on the relationship between the tables and select the appropriate relationships between the tables.

 

[Raven]

As you can see from the attached capture, they are joined by equal fields. I have a identifier field which joins each of the tables.

Any suggestions?

 

[Mile-O]

Go with option 2 in the picture