Hi all....
I'm trying to create a list of children to be picked up by parents. A
single parent may pick up one or more than one child.
I tried following the mail merge instructions on
http://support.microsoft.com/kb/294686/
And did this....
{IF{MERGESEQ} = "1" ""
"{MERGEFIELD "PickUp_Person"} "}
{SET Parent1 {MERGEFIELD "PickUp_Person"} }
{IF {Parent2}{Parent1} "First Child to be picked up: {MERGEFIELD
Name_First} {MERGEFIELD Name_Last}"
"Second child {MERGEFIELD Name_First} {MERGEFIELD Name_Last}" }
{SET Parent2 {MERGEFIELD "PickUp_Person"} }
I always get condition two (Parent2 = Parent 1).
So it shows the parent and "Second child xyz"
Then the next record again shows the same second parent and a new
"Second child abc"
I'm missing something simple here but can't seem to find it...
Any help would be appreciated.
Thanks,
Mike