I have many requirements to be able to show on a ListView/Combobox the results from multiple joined tables. (e.g.Show Transactions but join in the Stock Description from a joined file). I have gone through a lot of the threads here to get hints , and have it working fine on a Combobox , but would like to ensure there are no Gotchas for any of the other list types , or maybe there is a better way.

 

Any comments would be helpful

I see no issues with this approach, assuming your just using the dummy BO to get data. If you want to use it to update/add/delete data, it will get...er...interesting.



I used similar techniques for similar reasons (though it took me two years to figure out I could just type in the column names!) and it has worked great.



The single table thing is really only important when writing back to the db. It's pretty common to read all kinds of data into a BO. There are definitely different ways to do this, but not sure about better.



The only thing you might consider is looking into the FillMultipleDataTables method of a BO (static). This loads multiple BOs with one trip to the db and is a good thing to look into if a form is loading slowly. I had a form that was making something like 30 trips to the db when loading, due to a bunch of combos/lists. Switched to using FillMultipleDataTables, so all 30 got loaded at once and that really improved performance.