Help with my Query

[SFCMatthews]

Hello everyone, I have a problem I need help solving. I have a tblcompanydata, tblcategory, tblcommanddata and tbltrainingTaskdata. Everything is working just fine and normalized. But what I am wanting to do is; create a query that will show me base on the category and what command a company falls into, the training task they need to complete. I have a company form that I will eventually put a button on to run the query and show me a report of the training the company I am looking at on the form.

Tblcompanydata
UIC
UnitName
Fk_CategoryID
Fk_CommandID

tblCategory (There are over 8 Category's)
CategoryID
Category

Tblcommanddata (There are over 5 Commands)
CommandID
Command
Description

TblTrainingtaskdata (There are over 100 Task)
Fk_CommandID
Fk_CategoryID
Task#
Title

I have just shown you a small snap shot of each table. But, I have added the main components to the tables.