Before I begin, let me thank all the nice people who have responded to my previous questions - it's been tons of help. By way of explanation, I'm coming to Access application development having previously only worked with MySQL and PHP for web development, and the transition is less smooth than I would have hoped.

I have a table of names and a great many other tables that can be linked in some way through foreign keys to the names in the name_table. Now, I want to run a query that will return all other information I specify that relates to a single instance of a name in name_table, as opposed to running a query that will give me all the information about all the names in the name_table.

I assume that a) this can be done and b) that it's actually easy. However, I keep returning to a content management model I wrote in MySQL where I could just select the name from a drop down menu and the additional information would be assembled based solely on the name selected. Ideally, I would like to be able to run a report where name A is the only listing for which attendent records are recovered.

Hope this makes sense, and thanks in advance for the help.

-Yelena