well, it depends I think on what the parameter is/are.
I would think that you would like the tables together to get people in the organization and then outer join them to the training table.
Those that have a NULL for the event in question would be who your after.
If your allowed/comfortable with SQL, I would say create a stored proc and use that to retrieve your data. You can make sure that the data is what you are after, and you can 'see' the data that CR is going to pull back...it's not just a black box where magic happens when you use stored procs.
HTH
IP Logged
