No personal offense taken in the slightest, Erik...and hopefully none on your side. Just thought it was a great chance to poke a fellow FoxTexan in the (barbecued) ribs for a moment (g)

>Seriously, no personal offense, but I have never gotton anywhere trying to implement a cyclical relationship in a single query. If it doesn't bomb, it usually narrows the result set to nothing. I am really curious as to how your suggestion worked.
>
>
>>(chuckling)
>>
>>Gee, Erik, *really* appreciate all the confidence (g,d&r)
>>
>>Evan
>>
>>
>>>>>Hi Ken,
>>>>>
>>>>>Without knowing the fields you want, or the names of the detail tables, here's my best guess at what you're looking for:
>>>>>
>>>>>-- code snip follows --
>>>>>
>>>>>SELECT ALL ;
>>>>> SoMaster.Field1, ;
>>>>> SoMaster.Field2, ;
>>>>> SoDetail1.Field1, ;
>>>>> SoDetail1.Field2, ;
>>>>> SoDetail2.Field1, ;
>>>>> SoDetail2.Field2, ;
>>>>> ;
>>>>>FROM SoDetail2, SODetail1, SoMaster ;
>>>>>WHERE SoDetail2.ItemNo = SoDetail1.ItemNo ;
>>>>>AND SoDetail1.SoNumber = SoMaster.SoNumber
>>>>>
>>>>>-- end code snip --
>>>>>
>>>>>You don't need to link the two detail tables together, since you're already linking the master to the first detail table and there's a common link between the two detail tables.
>>>>>
>>>>>Evan Pauley
>>>>>
>>>>>
>>>>>Ken Morehouse wrote:
>>>>>>Hello all,
>>>>>>This is probably a question that has been asked numerous times, but I have an urgency.
>>>>>>
>>>>>>Scenario:
>>>>>>1 Sales Order Master Table and 2 detail tables
>>>>>>I need to select all SO's for a given customer from the master.(This is no problem). Next I need to select the item detail from 2 separate tables. the 2 detail tables need to link to the master by SOnumber, and to each other by SOnumber and ItemNumber.
>>>>>>
>>>>>>Any ideas? I'm racking my brain on this one. I have fallen on the wayside from coding anymore, but need to get this project out for the sales dept ASAP. ANY HELP WILL BE GREATLY APPRECIATED!!
>>>>>>
>>>>>>Thanks in advance,
>>>>>>Ken Morehouse, MCP
>>>>
>>>>
>>>>THANKS A MILLION!!! That was what I needed.
>>>
>>>That worked??

Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?