General information
Title:
Combining Child Recs into a Flat File for Export
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only