I'm working on my first database, one to manage risk on multiple projects. I've been able to write a query against my tables to return a combined list of the risks for all the multiple projects. I want to produce a list of all the risks for the individual projects to use as a combo box in a risk mitigation form. Is there a good way to reduce my data from the first query to only show the risks associated with a selected project? Help would be greatly appreciated (it's probably easy for those with more database experience than I).