I have a form where I enter information into a table. There is a drop down menu in the form where the id is connected to another table. Basically I'm pulling names from another table. I've got an id that connects fine.

However, I'd like to pull 2 columns into the one drop down menu selections. I n my other table I have a firstname and lastname column. I'd like to pull both those columns into the one drop down menu.

Ideally each line in the drop down menu would read "lastname, firstname"

Thanks in advance!

Peter T