Make a form with data across several tables

[goodguy]

I have several tables that are chained to each other in a straight line, like Clients --> Orders --> Products --> Components --> Parts --> Materials.
I would like to make a single aggregate form to give the user ease of access in using the app.

I am fairly familiar with Access, having used it off-and-on since 1995, and I am fairly good at programming in VB6, .NET and SQL, so I know a bit about subqueries, etc, and I also know how fast nested subqueries can become unwieldy.

Of course, I will have separate forms for managing individual tables and will provide the user with handy links to these from the main form.



So the $6M question is: is it possible or even advisable to attempt such a feat in Access?

[goodguy]

<bump>
So many views and no replies - funny!
Or maybe I did not make myself clear?

[goodguy]

While subforms filter records based on the selected parent record, some of my subforms will filter records on the grandparent record, e.g. show ALL Products in the order, all Components of each product, and cascading downwards to BoQ.
I shall be grateful for any advice on this.