Grid Filter Mode With LookUp

OrderIDCustomerIDFreight
10430 ERNSH 458.78
10436 BLONP 156.66
10438 TOMSP 8.24
10440 SAVEA 86.53
10441 OLDWO 73.02

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