Hi,
Let me preference by stating I'm not very good with lsp and this is my first attempt at trying to create a table with lsp. My issue is I'm no looping properly, but cant figure out the proper way to get it to work. If you look at the code you'll see I open 2 record sets. I open recordset 1 and then open recordset2 and loop through and then back to recrordset1. When I just look at the sql side of things it is looping through the records properly. But when writing the table portion I'm not able to get it to write the data in the same sequence. Meaning it is writing recordset 1 then recordset2 then recordset1 then recordset 2. What it should be doing is writing recordset1 then looping and writing recordset2 3 times then recordset 1 and then recordset2 3 times and so on. Here's some screen shots of the invalid sequence and then what I'm expecting.
Any and all advice is appreciated.
thanks