This has to be done in several steps:

• Merge persons file (PR) to women file (IR) to get SH38 into woman's file
o PR: HV001, HV002, HIDX
o IR: V001, V002, V003
o Output to TEMP1
• Merge persons file (PR) to children file (BR) to get SH38 into child's file. Not all children are household members
o PR: HV001, HV002, HIDX
o BR: V001, V002, B16
o Output to TEMP2
• Merge mother's file to children file. One woman can have several children, but all children should have a mother
o TEMP1: V001, V002, V003
o TEMP2: V001, V002, V003
o Output to final file