Well, consider this.

I'm trying to populate a list:

Client    Address      City    State   Zip   Phone   Email
-----------------------------------------------------------

When the user clicks on a header, the list will sort accordingly.
The problem is that the data is in 4 separate tables.

One client, many addresses, phones and emails.

Ideas?





>Yes, but you should know that VFP will only join two tables at a time, so at best you'll only get partial optimization.
>
>
>>Is it possible to join more than 2 tables:
>>
>>I have customers, with a one-to-many's into 3 tables, addresses, phones and emails.
>>
>>I need one record for each client, addresses, phone and email combo.
>>
>>Addresses, phones and emails are linked to the client record via a pivit table
>>called Links.
>>
>>Thanks