Forms query on a non base table item

From: Bob Hirons <bob_hirons_at_hotmail.com>
Date: Thu, 15 Apr 1999 15:30:25 +0100
Message-ID: <3715F801.7CDA5D7_at_hotmail.com>

[Quoted] [Quoted] How do I code a form to allow query on a non base table item?

e.g.
base table ORDER has-
ORD_NO
ORD_DESC
CUSTOMER_CODE table CUSTOMER hasCUSTOMER
_CODE
CUSTOMER_NAME [Quoted] form has items

ORD_NO                        base table item
ORD_DESC                    base table item
CUSTOMER_CODE       base table item
CUSTOMER_NAME       non base table item

Wish to allow query on CUSTOMER_NAME. Received on Thu Apr 15 1999 - 16:30:25 CEST