> > SELECT A.OrderNo,
> > A.CustNo,
> > A.... etc, etc,
> > B.Name
> > FROM Order_Comm A
> > JOIN Cust B ON B.CustNo = A.CustNo
> > WHERE A.OrderNo = :qOrderNo

Since you have the OrderNo as a parameter, I assume you are using a form to add
new orders. In this case, I just use two queries, one for the OrderNo, and one
for the CustNo details. When the CustNo entry is changed it just updates the
parameter on that query. There is also an option for a pop-up to ask if the
correct customer details have been displayed, if not, then you get a search on
Cust to find the correct CustNo.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services