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

  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
Who is Participating?
It would make sense to merge fields during the query.
jdinesAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.