Subject Re: [IBO] Query / join question
Author Nico Callewaert
Thanks Lester for the tip,


Nico Callewaert
Trislot n.v. - Waregem - Belgium

----- Original Message -----
From: lester@...
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

Stamp powered by

Click here to join YOPTIN and WIN COOL PRIZES

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