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