kreisel

How do I report only a found set?

Discussion created by kreisel on Aug 14, 2012
Latest reply on Aug 14, 2012 by kreisel

Maybe my title isn't quite correct, and perhaps this is very simple, but I'm still green!

 

I have a database with tables:

 

Events

EventItems

 

(among other tables I am not listing to try to keep this simple)

 

On my EventDetails layout, I have a portal that contains the EventItems table to list all the items that particular event will need.

 

Screen shot:

 

Screen Shot 2012-08-14 at 15.21.17 .png

I am having problems with my "Quote" report that I built. The layout is in list form and is displaying ALL the records in the EventsItems table as opposed to just the records with apply to this event.

 

Screen Shot 2012-08-14 at 15.36.52 .png

 

What is the best way to only show the records needed?

 

Thanks!

Rob

Outcomes