Grid Filter Mode With LookUp

OrderIDCustomerIDFreight
10348 WANDK 0.9
10365 ANTON 22
10367 VAFFE 13.55
10375 HUNGC 20.12
10380 HUNGO 35.03

CustomerID

  normalfiltercancel

Text Comparison:
Contains  Starts With   Exactly   
Connect all fields using:
AND  OR

Filter - DropDown Selection Box
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Mydb As New Tornado.z
  With Mydb
    .dbQP = "U=6| S=France| D=nwind| ni=none|th=Ti=Grid Filter Mode With LookUp"
    .dbMode = "Ty=Grid| FilterStart=t"
    .dbSQL = "SELECT OrderID, CustomerID, Freight From Orders"
    .dbCommonTables = "Index=CID| Q=Select DISTINCT CustomerID From Orders"
    .dbFilterFlds = "Fi=CustomerId| Ty=SB| Val=CID"
    .dbOptions = "Dropfirst=[Select an Item]"
    .ASPdbNET()
  End With
End Sub
</script>

Send comments on this topic.
Copyright (c) 1998-2006 ASP-db