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