Problem:
Two tables: one parent , one child. The relationship is one-to-many.

(In reality I have 10+ tables to perform this operation on, but two tables will suffice for an example of the problem).

I need a flat file to do a mail merge with Microsoft Word. Suppose the parent table has the name of a mother and father, and the child table has the names of their children.

PARENT.Mother = "Jane Doe"
PARENT.Father = "John Doe"

CHILD.Name = "Mark"
CHILD.Name = "Sally"
CHILD.Name = "Jessica"

I need a record like this: Mother, Father, Name1, Name2, Name3

I achieved this result while playing with SQL in the command window (FoxPro 2.6) several years ago by accident. And I have absolutely no clue how to reproduce it.

David