hi.

I have a datatable object in memory and I want to separate it into 2 tables wich they are mater-detail. I know how can I make relationships between two tables, but I don't know how can I make a datatable object from another datatable object. (Because of my app limits, I can't change source datatable or select statement)

as a simple example, suppose that my datatable has these columns:

Customers_Orders:( customerName, customerID, orderID, orderDate )

Now I want to make two datatables with these colums:

Customers:( customerName, customerID )

Orders:( customerID, orderID, orderDate )

Then I want to relate them in a dataset object. How can I do that???

Thanks for your help.