Another way of doing it without making a trip back to the database is to use a calculated column in your datatable. Then bind to the calculated column.
For displaying the related column, set up a relation and use a calculated column that refers to the parent or child datatable.
http://www.devx.com/vb2themax/Tip/18863Or you can create your own control. See
http://www.codeproject.com/vb/net/multicolumncombo.asp?target=multi%7Ccolumn%7CcomboboxObviously you would have to make the control implement some of the MM.NET binding interfaces to integrate it with the MM framework.
>Hi,
>
>
>I use a combobox to provide a picklist of employees. What can I do so that I can set the
>BindingSourceDisplayMember to be firstname +¡¯ ¡®+lastname, instead of only firstname or only lastname? What should I do with the employee biz object and the data form?
>
>Is it possible that I go even further so that BindingSourceDisplayMember can be firstname +¡¯ ¡®+lastname + ¡® ¡®+ position, with position in a different but related table?
>
>Chen