Back ground: I have 2 tables CD and Artist. CD has an Artist_FK that joins the Artist table. I want to show the name of the artist from the Artist table, in the search result of the browsedialog instead of the foreign key. I have setup a custom field and it shows in the drop down of the browsedialog browseresultslayout.

When I click the search on the browsedialog I get an error. Artist is not recognized. When I walk through the debug code I see the browsedialog creates it's own fill method to return the results instead of using my fill method that contains the join. Is there a way to specify what fill method to use or a way to include my joined field?

thanks

Bill

Hi Bill,

Glad it work for you, but keep in mind that this method will do a trip to the database to get the Artist Name value to be shown in the listview, this is acceptable in most cases if your search in the BD (Browser Dialog) will not return many records, but if that is the case, there are many alternate methods like Trent and Ivan said, in which you can use either use an Scalar method to just return the Artist Name field or to create a temporary BO in the BD with all the Artist Name and use the BO.SeektoPrimaryKey(Artist_FK) to get its name in the RowPopulation event.

Edhy Rijo