Listing fields

[geraldk]

Yes I have code that will enter in the Primary Key. I can add to training to another employee but when you want to list available courses to employee 1 it won't list all couses just you will see what they have taken.

[June7]

Guess I don't understand what you want this query and listbox to show.

If you want to show what courses are available for each employee, does that mean you want to show only the courses each employee has not yet completed?

[geraldk]

Yes I want to show what courses are available for each employee. I guess I want two queries, the other one to show all courses available and in that one which courses employee has taken.

[June7]

Still not sure I understand.

You want queries for:

1. Only the courses each employee has not yet completed?

2. Show all possible courses and an indication of which courses each employee has completed? I think this will be difficult to show in one query and will mean a lot of replication of course listings. Is each employee required to take the same set of courses?

[geraldk]

Question 1: Yes

Qustion 2: Yes, if possible. Would like this in a report if possible.