Hi,

I would like to know how you would relate invoice and invoice details file , or a purchase order and purchase order details file, on a form.

Presently I am coding in the Load() event of the main PO form (frmPO), which displays the PO and also displays within a Grid the items of the PO, stores in the PO_ITEMS table. They are bothed indexed on PONO.

SELECT PO
SET RELATION TO PONO INTO PO_ITEMS

I have "ADD", "Edit", "Remove" command buttons on the main form which is used to Add, Edit or Remove a PO item, respectively.

After the user "Adds" a new item, I code the following to display the list of items for this PO:

SELECT PO_ITEMS
SET FILTER TO PONO=PO.PONO

Is this correct, or is there a better way to handle this?
Would this work fairly quickly if my PO file and PO_ITEMS file become huge?

I am fairly new to VFP 6.0, and would like some advice.

Thank you very much in advance!