Navigating through tables to item
I've managed to link 4 tables with the help of the forum (showthread.php?t=4658) which has achieved most of the functionality required but I'm struggling to navigate the way I need to. The four tables are Items (main table with foreign keys), Types (child 1), Makes (child 2) and Styles (child 3). Basically I want to start with a list of product types. That then links to a list of product makes of the chosen product type. That then links to a list of product styles of the chosen product make and finally link to the detail page of the actual item. I appreciate CSS Menu Writer goes someway to dynamically achieving this but need to do it going from results page (type) to results page (make) to results page (style) to get to the required detail page (item). Could I see what the dynamic link code should be stage by stage and the record sets, including sql code. I've tried following other examples but get lost at the second stage. Also, am I missing a trick using DateAssist. EG just run the Wizard 4 times and then hand code the sql?
