Put the record even if the result is blank 1

[RSX02]

Hi
I have 2 tables link together by a field that is called 'key'.
My first table is called po and the second one is called Notes.
I would like to display (in impromptu) all po even if they have notes or not.
The problem is that I put the fields:
po.po-num
po.key
notes.key
notes.txt
in my report but when I don't have notes on the po it doesn't display they po anymore. I would like that it display even if they have notes or not.
Thanks in advance

 

[sharatkb]

Hi,

You could try applying outer-join between the tables to fetch all records from 'po' even when 'notes' don't have them.

Hope this works...

Regards,