Filter across tables

I have a number of assets (automobiles) The automobiles have a number of tyres fitted.

plus an exhaust to reduce emissions. With a number of automobiles comes lots of tyres and exhausts.

I have created 3 tables. The first one is for the “Automobile” with a unique ID.

I linked the other two tables (“tyres” and “exhausts”) using the unique ID.

How do I choose an automobile (ID) and filter and show in the other 2 tables so as to show just the attached tyres and exhaust for that unique ID.

is this possible.

Many thanks