How to apply one filter on multiple tables?

Is there a way to synchronize filters between tables?

Table A: users
Table B: books
Table C: movies

I want to print books and movies for a single user.

I go to table B: filter them by user name. Then I print it.
I go to table C: filter them by user name. Then I print it.

I’d like to apply one filter (by user name) on both tables at once.

Is there a way to do that?

Have you tried using Interface Designer? I was able to build something like this using the “Record review” layout. The main record list will be from your [Users] table. Add an element to the design from the link field that connects to the [Books] table, and choose a grid. Do the same to add a grid for the [Movies] table using the user’s links, and place that grid next to the [Books] table grid. Now when you select a user from the list on the left, the grids will show that user’s linked records from both tables in one place.

Printing this is the tricky part. My initial tests didn’t include the full window in the print, so I had to start scaling the output to fit the page. Another option is to just screen-grab the part you want (like the snippet below taken from the base for my online class) and print it later.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.