Sorry, I guess I didn't make all the details clear - no datasessions, no remote views, I am using DataClas/VFP to interface to SQL Server. Your second paragraph is right on the money, that is indeed how the data is laid out - see my reply to Nadya.
I guess all i was looking for was how to present the search choices to the user - two different search buttons with different icons, a choice dialog that pops up after the user clicks the one search button, etc. As in, which method (or another one I haven't considered) makes the most sens from a consitent UI standpoint, and for ease of use. The typical user of this application will not be a computer expert.

Randy

>I would create a second Form entirely for this, with a separate Private datasession. Also, you will have to 'reverse' the Relation to create a relation from the Child into Parent, probably just a simple one-to-one relationship...it's actually many-to-one but they can't search as easily that way.
>
>Also, realize that many Children can have identical IDs but different Parents, so the users will have to choose which one they want.
>
>HTH,
>
>-Irv.
>