How to apply one filter on multiple tables?

Topic Labels: Base design
1298 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1

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.

Screen Shot 2021-11-20 at 3.51.14 PM