>>Ok. As it stands, you're doing a SELECT command (or an RQBE -- same
>> difference), and telling it to show fields from both tables. Since there's a
>>one-to-many relationship, Fox has to fill in records from the one side
>>many times, and those are your "duplicate" records.
>>

     p1f1  |  p1f2  |  child1
     ****  |  ****  |  child2
     p2f1  |  p2f2  |  child3
     ****  |  ****  |  child4
     ****  |  ****  |  child5

>Garrett
>I See what you are saying, but I am doing a SQL-Select statement and
>putting the results into a cursor. How do I get the cursor to be in the
>format that you just described?

I may be wrong here, but I'm reasonably sure that the answer is, "You don't." I believe that the only way to do this is to use two tables. Can you give more details on what you're trying to do/show? I can try to come up with an alternative for you...