Master Detail - Master Report Rows doesn't match master detail scroll
Hello,
Another rookie question. I created a master detail form and report. I am controlling the report with a where clause to only view the rows where the current application user is the record owner. For example, my app user login is the email address of the user. Then I filter the rows to only display the rows associated to the users email address. So, if the table contains 100 rows, only the 10 rows that the user is associated with, displays in the report.
When I drill into a record, i am presented with the correct master detail form with the correct data, however, when I click the Next and Previous buttons, I can see the entire record set. For example, if I only saw 10 rows on the report, I can scroll through all hundred records once i drill in from the report.
How do I limit the data to match the visibility that i set at the report.
Thanks!
-Brent