David,

Thanks. Worked perfectly.

A followup question:
After I do the merge, there is no index for either the merged table name nor the merged column names. How to I add/set them?

Thanks Again,
Doug
>To set a relationship between 2 tables, they need to be in the same dataset. How Do I add DataSet2 to DataSet1 above so that the following will work:

DataSet.Merge

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconmergingdatasetcontents.asp