I have a sql in which i am select some fields from table1 and table2 join by a report_id. In table1 there exists Payment_ID. In my list box, am getting the value of Payment_ID like this<BR>&#060;Select NAME="PaymentIDList">&#060;option SELECTED value="&#060;%=("Payment_ID") &#037;&#062;"><BR>&#060;%= Form_Payment_Type &#037;&#062;&#060;/option>&#060;/select>. It&#039s selecting the correct one however, am not seeing the other choices of Payment_ID eg 2,3,4 etc. Am only seeing 1. How do i get it to have the others in the box as well. <BR><BR>Question#2> What i really need is the Payment_Name which is in table3 which i did not select/join in my sql. Do i create another sql and select the Payment_Name or what????????? Suggestions please.