Perfect! Thanks!


>>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.
>>

>
>

>select Contacts.*, Phones.Caption, Phones.Phone ;
>  from Contacts ;
>  left join links on Contacts.RecordId = Links.ParentID ;
>       and Links.Key == 'phone' ;
>  left join Phones on Links.DataID = Phones.RecordID
>

>However I suggest you to rethink about this design. Instead of holding multiple link info in a single table having them in separate files is better IMHO (and if it's not for supporting many-to-many completely remove links for these 2 tables).
>Cetin