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