Hello,

In one instance in my application, I wanted to merge 2 fields in my combobox for display purposes, so I modified my SQL statement like so:

SELECT Customer.*, [CustomerName]+' - '+[CustomerContact] AS CustomerDisplay FROM Customer

I created a dataview from this table and bound my combobox to it.

The question I have is did I have to do that in the SQL statement? Do Dataviews have the functionality to accomplish that?

TIA,
MAC