>It does. In fact, my example had an error because I usually put FK in front of a foreign key and PK for a primary key. The example should had been written:

Customer.DBF
>------------
>PKCustomer (with a primary key index)
>CustName
>...
>
>Orders.DBF
>----------
>PKOrders (with a primary key index)
>FKCustomer (with an index called FKCustomer)
>Item
>...
>
>USE Customer
>USE Orders IN 0 ORDER FKCustomer
>SET RELATION TO PKCustomer INTO Orders

VFP will match the expression given in the SET RELATION with the current active index of the child to build the relation.

---

>Does the FKCustomer in you "SET RELATION TO FKCustomer INTO Orders" need to be in the Customer table? I think it does...
Hi Sylvain and thanks for the code... :)