Would you be able to post the packaged workbook? It's hard to say what's going on without being able to see how everything is set up.
Edit Relationships makes me think you have a data blending scenario set up... two (or more) separate data sources? This can add to the complexity.
Action filters are the way to go, but as Tracy said, we cannot be of much help without seeing the data and a packaged workbook.