>Robert,
>
>>I need some code samples of SET RELATIONSHIPS. I can not
>>seem to set a realtionship.. thanks
>
>Suppose you have two tables, customer and invoice. Customer has field cust_no, which also is included in invoice. Invoice has an index tag on cust_no, called cust_no.
>
>USE invoice ORDER cust_no
>SELECT 0
>USE customer
>SET RELATION TO cust_no INTO invoice
>
>Now, as you move through the customer table, the record pointer in the invoice table will automatically move to the first matching invoice for that customer.
HI David and thanks....:)