Anyway to display data from two unrelated tables without creating another table?

[kelkan]

I have a database with several tables. One is tblEmployees (primary key is EMPLOYEEID) and it lists information about assigned employees. A second table is called tblCourses (primary key COURSEID) and lists all of the available courses an employee can take. Many of the classes are mandatory for employees to complete each year while others are optional. I have a third table called tblTraining (primary key TRAININGID) which combines the employees and courses into one table; however, this table is only populated as employees are signed up for or complete a class. I have a one-to-many relationship between tblEmployees and tblTraining. I have a one-to-many relationship between tblCourses and tblTraining. I am trying to create a document (query, form, whatever) that can combine the employees with all of the required classes so that I can see which employees have completed/still have to complete required classes. tblTraining only lists classes already taken or signed up for....The information I need to determine who has/has not taken all required classes lies in tblCourses and tblEmployees but I have no relationship between the two. The only answer to this puzzle that I can figure out is to have another table called tblRequired (primary key REQUIREDID) and Dlookup names from tblEmployees and then manually create a record with each employee in it, then have fields for each of the required classes as a yes/no field. Suggestions for an easier way to do this?

[June7]

Try:
Create a query with tblEmployees and tblCourses without a join. This will cause every record in each table to join with every record in the other table. This gives a dataset of every possible employee/course combination. Then join that query to tblTraining, jointype "Include all records from [query] and only those from tblTraining ...", do a compound join on employeeID and courseID fields.

[kelkan]

I created the query for tblCourses and tblEmployees and created a dataset for all combinations. I don't understand what you mean by join that query to tblTraining. Do i join them in another query or directly to tblTraining? Do I only need to use EMPLOYEEID and COURSEID from the query I created or what? Thanks for your time to help me out.

[June7]

Build two queries:

Query 1
with tblCourses and tblEmployees

Query 2
with No.1 query and tblTraining, compound join on employeeID and courseID fields, jointype "Include all records from query1..."

Now should be able to see employee/course combinations not in tblTraining.