Repeating table and repeating nested row
I have read and reread several posts regarding nested repeats. Tried the David Powers approach and tried Tom Mucks extension and I am not sure either of those work for my situation or at least I need some advice as I am becoming confused.
I have 3 main tables: LINE; SERIES; FIGURES
FIGURES is a child of SERIES and SERIES is a child of LINE (if that makes sense)
Each table consists of many columns but for clarity these are the ones that matter in this post.
NOTE: from now on I plan to use camelCase for my columns names; thanks Jason.
LINE - Line_Id, Line_Name
SERIES - Series_Id, Series_Name, Line_Id
FIGURES - Figure_Id, Figure_Name, Series_Id, Line_Id
I have a Line_Details.php page that you get to from the Line_Results.php page. On this page I show all of the details of the LINE table.
I also have a repeating table with two rows. The top row contains the SERIES that are attached to this selected LINE. For example I have selected the LINE Star Wars from the results and am showing the details for it. There are 3 SERIES that belong to Star Wars in the series table (Vintage, Legacy, Clone). So I have 3 tables that appear on the same page each with the correct Series_Name and the rest of the details.
My issue lies in that I want the second row to list some details of the FIGURES that belong to the SERIES of each repeating table.
I figured repeating the table was easy and then repeating a row inside that table would work but CS4 says otherwise. All the examples I've seen are simple lists with only a column but I need to repeat a row as I need to have dynamic links to detail, delete, update links as well.
You can see it in action here to understand.
I just need some direction more than anything. Currently I am using only one recordset with INNER JOINS for the SERIES and FIGURES tables. I've tried using 2 and 3 recordsets and several methods including the Tuck and Powers way. I'm just confused and need some expert pointers of how you'd go about it. I can provide files/zips as needed.