Need Help with access 2010

[vaidehikumar]

I have two tables Invoice and payment. In the invoice table I have job number, Invoice number and Invoice amount, and in the payment table I have Job number, invoice number and payment. I would like to do an Outstanding invoice subform in the payment form, where it will show all the outstanding invoices as soon as you enter the job number.
My subform shows the info only for the invoices that got paid in full or partial payments. If the invoice never got paid it is not showing up in the list, since I have the query results joining the two tables (invoice and payment). How to bring all the records from the invoice table minus payments, even if there was no payments on an invoice. Thank you for the help.

 

[pbaldy]

As answered elsewhere, edit the join between the tables.