Think I need to use IS NULL as OR but not working.

[Guest]

Hi I have a simple query that is not providing the results I need. Below shows part of the design view

table a table b table
*********** ********** *********
* pri-key inta * |------------* pri-key b_id* *pri-key c_id*-------->to c_i
* int b_id *----| * char bdesc* *char cdesc
* int c_id * *********** **********
**********
above shows the relations, and I am displaying inta, bdesc, cdesc from the query results. The problem is when
there is no int b_id entry for table a, I still want to list inta and cdesc for that item but there is no record returned
Thanks

 

[Guest]

Figured it out, just had to change the join properties on the relational link.