🚀 go-pugleaf

Thanks for replying Bill!
I'll try to put it clear:

the SELECT statement I've posted is supposed to be the SelectSQL of my
Purchase_Orders_Items table. It is the detail table of other that has the
fields NUMERO and ID_TIPO_DES. I insist in this matter, because I know that
the master table will pass the parameter for NUMERO (that's the PK) but:

it will pass the parameter for ID_TIPO_DES ?? if doesn't here I have my
first problem. This field represent the "kind of description" of the items
in all the lines of the purchase order (I.e.: all the descriptions may be in
English or Spanish) The user types it when he creates a new purchase order.

I need to show all the selected fields in a dbGrid. But I only see the
fields that belongs to the main table (ORDEN_COMPRA_1) the others remain
blank. Actually when I pull down the listbox in order to choose the field
name in the FieldName property of the column property of the dbGrid I see
only the fields of ORDEN_COMPRA_1.

I'm not using the JOIN clause because I don't know how to use it with more
than 2 tables.

Here I post the select again:

select
   oc.*,
   des.NOMBRE,
   ar.CODIGO, ar.CODIGO_BARON,  ar.CODIGO_S_PROV
from
   ORDEN_COMPRA_1 oc,
   DESCRIPCIONES des,
   ARTICULO ar
where
   oc.NUMERO = :NUMERO  and
   oc.ID_ARTICULO = des.ID and
   oc.ID_ARTICULO = ar.ID   and
   des.ID_TIPO_DES = :ID_TIPO_DES


Thanks again!


Sergio