pgollnic 0 Newbie Poster

I have a parent/child relation I am trying to create fow 2 datasets.
The parent ds consusts of a range of PO Header information

After I fill this dataset I loop through it getting the PO number. I then take that value and execute another sql statement on the DETAIL file and fill a dataset(dtlDS) for EACH row in the parent. How do I add to this dtlDS for each row? I am getting no CHILD data in the merge. Should I be filling to a datatable and do an add.row and THEN dump into the dtlDS??

Thanks

gollnick
__________________

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.