Michel,
You can't combine multiple tables inside the DataSet. You will need to do that in your select stmt when retrieiving records from the backend.
>>You can't use UNIONS when select a DataView. The data only comes from the DataTable associated with it.
>
>Can I do it from the DataSet directly?
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi