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
__________________