Thanks Lester for the tip,

Greetings,

Nico Callewaert
Trislot n.v. - Waregem - Belgium
ncw@...
nico.callewaert@...

----- Original Message -----
From: lester@...
To: IBObjects@yahoogroups.com
Sent: Saturday, May 19, 2001 9:16 AM
Subject: Re: [IBO] Query / join question


> > 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





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Stamp powered by www.mailround.com

Click here to join YOPTIN and WIN COOL PRIZES




[Non-text portions of this message have been removed]