Creating a Query to show all possible combinations?

[Shura]

Hi All,



I'm currently making a Database to track training on machines. Each machine has 10 criteria that needs to be assessed.
I currently have 3 tables. One for the Trainee (Key feild TraineeID), One for Machine (Key Field MachineID) and one for the Criteria(Key Field CriteriaID)

What I have been racking my brain trying to figure out is how I would create a query that would display all possible combinations for these three criteria
. I've worked out there are about 4000 or so possible combinations, and with new staff coming and going it would make filling in this table incredibly tedious.

Here's an example of what I'm talking about. Does anyone have any suggestions? All help is very much appreciated!

Example:

TraineeID	MachineID	CriteriaID
1	1	1
1	1	2
1	1	3
1	2	1
1	2	2
1	2	3
2	1	1
2	1	2
2	1	3
2	2	1

[Shura]

Well, after some tinkering I managed to figure it out.
I built a query and removed the relationships between the tables (Trainee, Machine, Grading) and just had the query run using the ID from each of these tables. That generate the full list of possible combinations. I hope this manages to help someone!