1 to Many relationship question

[Poptartme]

Table 1
Item No
A
B
C
D
E

Table 2
Item No Sales
A $10
B $20
C $30

I want to be able to select all items from Table 1 and matching records from Table 2. I want the result to look like this:
Item No Sales
A $10
B $20
C $30
D $0
E $0

I do 1-to-many from Table 1 to Table 2 but I only get the matching rows i.e. item A, B, and C only.

Any help will be much appreciated.

Thank you!

 

[Vassago]

If you make a query, right click on the line that joins your two fields and select "Include all records from Table 1 and only those from Table 2 where...etc." It should work for you.