Dynamic Report

I have a query that displays related data (one to many). I want to create a report that will print only the MANY from a specified ONE (of which there are about 15).

I plan to give this to a couple other end users, so my solution has to be fairly simple; select a ONE and generate a report for printing.

Is there an easy way to tell the report which set of MANY to display without making a separate query/report pair for each ONE?

Be gentle, it's my first time...

Turn you query into a parameter query


SELECT TableOne.Field1, tableMany.Field1, tableMany.Field2
FROM TableOneINNER JOIN tableMany ON TableOne.Field1= tableMany.Field1
WHERE (TableOne.Field1=[Enter Selection]);

[Enter Selection] - is the criteria which drives which on the one that will be used

S-

of course!

I'm an idiot.