Close. The phone records appear as separate record before
the contact records.

>

>SELECT Contacts.*, Phones.*;
>       FROM Links;
>       LEFT JOIN Contacts ON Links.ParentId = Contacts.RecordId;
>       LEFT JOIN Phones   ON Links.DataId   = Phones.RecordId;
>INTO CURSOR cAllPhones
>

>Is that what you need?
>
>
>>I have a Contacts table. I also have a Phones table. They are related
>>through a Links table. I would like to pull the client record, and have
>>all the phone numbers on the client record.
>>
>>Anyone?
>>
>>
>>The relationships:
>>

>>Contacts
>>   |
>>   -< Links
>>       |
>>       -< Phones
>>
>>
>>
>>The structures:
>>
>>Contacts
>>RecordId  FName   LName
>>-----------------------------------------------------
>>00000001  Joe     Smith
>>
>>Links
>>RecordId  ParentId  DataId    Key
>>-----------------------------------------------------
>>AAAAAAAA  00000001  ZZZZZZZZ  "phone"
>>AAAAAAAA  00000001  QQQQQQQQ  "phone"
>>AAAAAAAA  00000001  FFFFFFFF  "phone"
>>
>>
>>Phones
>>RecordId  Caption         Phone       Last
>>-----------------------------------------------------
>>ZZZZZZZZ  Home            8005551212  .T.
>>QQQQQQQQ  Business        8001212555  .T.
>>FFFFFFFF  Cell            8885544877  .T.
>>