Member Avatar for Antpit
Antpit 0 Newbie Poster

Hi

I've got a 2 col drop down list that gets its values from an SQL Server DB Table called List. The field that the drop down list uses is called SurName this would only display the surname for each record in ascending order.

I have now extended the drop down list to show the surname and forenames like this

SELECT ListID, SurName + ' ' ForeName AS ListName FROM LIST

the new drop down list now shows the surname a space and a forename for each record in the table.

I now want to connect a FormView control to the new drop list to view the data as selected from the drop down list. I had it working before when the drop down list used only the SurName (using the WHERE button) field but it does not work now with the new ListName field

Antpit

  • 1 Contributor
  • 0 Replies
  • 54 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.