• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

Populating drop down list with data from two columns in SQL table - best approach

Hello,
  I need to create a form that includes a dropdown list of our sales staff.  The table that contains this data has the first and last names seperated.  In order to combine those two columns should I run a query to merge the columns first and then create the combo box or is there a way to do it all at the same time?  Thanks
0
jdines
Asked:
jdines
1 Solution
 
pritamduttCommented:
It would make sense to merge fields during the query.
0
 
jdinesAuthor Commented:
Thanks
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now