🚀 go-pugleaf

Hi! (using borland c++ 5.01)

I am trying to make a database that allowes the user to view all orders
placed by a specific customer.  I have setup a dialog box that containes

data - aware components to navigate through a customer table.  I have
been trying to then insert a SSView (TGrid) component, that displays all

the orders a particular customer has made.

I have linked the grid to a second datasource which is linked back to a
TQuery control. The TQuery is linked to dataset 1 (assigned to the
customer table). And then i have inserted the following SQL suggested in

the on-line help:

SELECT Orders.CustNo, Orders.OrderNo, Orders.SaleDate
   FROM Orders
   WHERE Orders.CustNo = :CustNo

The problem is that when i preview or execute the dialog box the grid
only shows orders
for customer 1, and does not change as i select different customer using

a navigator.