I have a datagrid that I have populated using OleDbDataAdapter, Dataset etc to an Access DB, I have used an innerjoin to populate the grid with data from two tables. This all works fine, but I now want to add a style to the grid so that I can give the grid proper header text. widths etc, I have done this but only the data from one tables appear once I have applied the style.

I think it is because I have used a mapping name for the style and I can only use one tables name (items).

tbltest.MappingName = "items"

How can I get around this?

Thanks in advance
Louisa

Need to join the tables in one record set and set the data source to that.

Set grdSearchResult.Recordset = objRs