Grid Filter Mode With LookUp

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



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

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]"
  End With
End Sub

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