## alternate recordsets

I had put up this question yesterday but maybe people got confused, but let me explain it in detail once again.<BR>I have 2 tables table1 has a column say "buy price" & table2<BR>has "sell price" .Also these 2 tables have a common field say<BR>"Idno".Now the number of buy price records for idno=1 in table1 is not necessarily equal to number of sell price records where idno=1 in table2<BR>That is for example table1 can have 3 buy price recs where idno=1 and table2 can have 7 sell price recs where idno=1.<BR>Now when I display these buy price & sell price values on the web page I can retreive all the buy price values at one time <BR>& then all sell price values through the method below.<BR>But what I want is alternate buy price & sell price values should be displayed & if the buy price or sell price values are <BR>not equal ie say Buy price recs are 3 & sell price recs 7 then<BR>the last 4 sell price values should be seen together.see below for example<BR>Buy price 45<BR>sell price 76<BR>buy price 33<BR>sell price 45<BR>buy price 45<BR>sell price 78<BR>sell price 43<BR> &#039&#039<BR> &#039&#039so on<BR>The method I had used was<BR>&#060;% do while not rs.eof%&#062;<BR>&#060;tr&#062;&#060;td&#062;buy price&#060;/td&#062;&#060;td&#062;&#060;%=rs("buyP")%&#062;&#0 60;/td&#062;&#060;/tr&#062;<BR>&#060;%rs.movenext<BR>loop%&#062;<BR>& #060;% do while not rs1.eof%&#062;<BR>&#060;tr&#062;&#060;td&#062;sell price&#060;/td&#062;&#060;td&#062;&#060;%=rs1("sellP")%&#062;& #060;/td&#062;&#060;/tr&#062;<BR>&#060;%rs1.movenext<BR>loop%&#062;<BR> But this gave me BP & SP all togethher.Could U pl help me put this in the alternate method I want.Thanx for reading & the help.<BR><BR><BR><BR>