🚀 go-pugleaf

I have created two tables.
 Archive.dbf is the invoice header record (name, address, date, invoice
number, etc.)

 Archivep.dbf is the invoice line information (invoice number, quantity,
catalog number, etc.)

An invoice is made up of one Archive record and one or more Archivep
records.  They are related using the invoice number field in each record.

The SQL query syntax is as follows:

SELECT Archive.INVOICE_NO, Archive.TERRITORY, Archive.TYPE, Archive."DATE",
Archive.OPERATOR, Archive.PO_NUMBER, Archive.SHIPTOPONU, Archive.SUBTOTAL,
Archive.TOTAL_AMT, Archive.DISCOUNT, Archive.CREDIT_AMT, Archive.CREDIT_NUM,
Archive.PAY_FLAG, Archive.CWO_LOC, Archive.TERMS, Archive.TAX_AMOUNT,
Archive.SHIP_CODE, Archive.SHIP_COST, Archive.HAZMAT, Archive.WEIGHT,
Archive.CUST_NUM, Archive.PRICE_LIST, Archive.BALANCE, Archive.RECEIVABLE,
Archive.DATE_PAID, Archive.SHIP_NAME, Archive.SHIP_ADDR1,
Archive.SHIP_ADDR2, Archive.SHIP_CITY, Archive.SHIP_STATE, Archive.SHIP_ZIP,
Archive.NUMOFLABEL, Archive.INVMEMO, Archivep.QUANTITY, Archivep.CATALOG,
Archivep.LOT, Archivep.PRICE
FROM "C:\ANCAL\INVODATA\archive.dbf" Archive
   INNER JOIN "C:\ANCAL\INVODATA\archivep.dbf" Archivep
   ON  (Archive.INVOICE_NO = Archivep.INVOICE_NO)
ORDER BY Archive.INVOICE_NO

This gives me the appropriate Archivep records associated with their Archive
record.  I want to further limit this to one invoice number so that a grid
on the form displays only the Archivep records that are associated with the
Archive record.  Presently, all of the Archivep records are displayed.

It seems to me this calls for a WHERE clause but I can�t construct one that
works.  How do I do that?