quries and subform

[trigstar]

i would like to run a query with two separate table with one table has in data and the other has non.
example i would like table Invoice#, Amount, Date to be shown as cash purchase and table Payment to be shown in a query. when i run the query i get a empty query because payment has not been done as yet but i would still like the query to show the other data even though payment is empty

[pbaldy]

Edit the join between the tables by double clicking on it. You'll see the appropriate choice.

[trigstar]

don't understand total nubie

[trigstar]

thanks you got it i hope lol

[pbaldy]

No problem mon!