I have a dropdown list... using a datasource... now, thats fine.

the data source is also connecting to the database perfectly.

the only problem is that i want two columns to appear in the text field of the drop down list...

in the format of Surname, Forename

how can i have two fields in there instead of the one?