Selecting data between 2 tables then grouping

[nicksource]

I have 2 tables that are related to each other.

When a user logs out products that go to a customer, the form stores the Date it goes out on, and the customer ID (shown as 'JobID' below), then another table, logs which products went and what quantity.

The tables are below:

The 'ID' field on the GoodsOutJob table is the ID used in the 'GoodsOutID' field in the GoodsOutProd table, to relate the 2 tables data.

The problem I have is, how do I make a query to show all the products where Job = 28 for example? I presume I need a Join query just not sure what to do.

I hope you understand,
Thanks in advance.

 

[nicksource]

Anybody?

 

[pbaldy]

If you join the 2 tables on the common field, you should be able to filter on JobID. Are the records with no GoodsOutID just from testing? In my mind, to be a candidate for a joining field it can't be Null.

 

[nicksource]

The blanks are from testing.

I've got a query to show all the ProdID in relation to the GoodsOutID, which is good, all I need to do now is sort it to a specific JobID only, do I do this with 'filter' or 'sort'? Where should I be looking?

Thanks,
Nick.

 

[nicksource]

Done it! Thanks.

 

[pbaldy]

Sorry, I was...sound asleep! Glad you got it sorted out.