In your last sentence you nailed it, DataAssist is the way to go. You can use DataAssist to create the results pages for each of the three tables, then craft the final details page for the items.
You could also make them your self pretty easily.
The idea is to do this one page at a time. On your first listing page you will have a recordset that selects all from the types table. After the recordset is on the page you will go to the bindings panel to create the listing on the page, you just drag and drop the values you would like to see on the page. Once they are on the page you just put a repeat region around them and specify all records.
You then make a dynamic link from one of the columns values on the page. This is a regular link with an id appended to it, the id value should come from your recordset.
This link will go to the next results page with the id for that type. On the next results page you will need to add a recordset to select all from the make table, but this time you will filter based on the id column being equal to your URL parameter. This is the id value in the link you created on the first page.
The process is exactly the same for the rest of the pages, create the design, add bindings, set the repeat region, then add in a link. Then on the next page start with your filtered recordset.
