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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer