<% 'on error resume next if request.form("sort") = "distributor" then ob = "customer" sel3 = " selected" elseif request.form("sort") = "status" then ob = "status" sel2 = " selected" else ob = "date_entered" sel1 = " selected" end if %>

RMA List

<% sql = "select dist_id,rma_id,rma_num,date_entered,customer,serial_num,status from rma where closed = 0 order by " & ob set rs = conn.Execute(sql) do while not rs.eof sql = "select business_name from distributor where dist_id = " & rs("dist_id") set rsX = conn.execute(sql) dist = rsX("business_name") %> <% rs.movenext: loop %>
Sort by:
Distributor Name Customer Name RMA # Serial Number Entry Date Status
<%=dist%>  "><%=rs("customer")%> <%=rs("rma_num")%>  <%=rs("serial_num")%>  <%=rs("date_entered")%>  <%=rs("status")%>