This is not possible without a bit of tweaking.
You either need to set your DB to reflect this, that is, split it in two table and make a relationship on an id field for each table.
Or you could try to make 2 data adapters, configuring a TableMapping on each. The 2 adapters would point to the same table, giving different names to the table, then you could add both adapters to the same dataset, and create a relationship between the two on the primary key field. The rest would be normal binding to the grid.
We have not tested this, so it is only suggestion.
Imported from legacy forums. Posted by André (had 2882 views)