Master Detail with SQL

From: graham (grmiller_at_tiscali.co.uk)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 08:37:51 +0100

Can someone point me to a source of knowldge for using TADOQuerys in a
Master Detail (Customer/Orders) form? The info I have uses ADOTable for
this. I would like to use ADOQuery because I have a neat search unit using
SQL which I cannot do with ADOTable as far as I know. I have linked the
Access tables OK successfully with
SELECT * from Customer, Orders
WHERE CustCode = OrdCode

This produces an Orders table with all Customers who have an Order, but it
needs to show only the Ordere ralating to the one Customer shown on the
form. So the fields match OK.

Can you help please?

Graham