Hey all, it's me again!
I have two Tables, each containing completely different styles of data: One containing Firefighter names, and one containing possible Duties.
How can I build a Query to give me a list of every possible combination of Firefighters/Duties?
For example: I have the following:
Firefighters:
Duties:Code:FFID|Firefighter 1|Rawb 2|TheShabz
How could I come up with the result:Code:DutyID|Duty 1|Driver 2|Salvage 3|Hose Operator
Code:FFID|DutyID 1|1 1|2 1|3 2|1 2|2 2|3