I have a drop down menu that's fed by an SQL database for a timecard. This database has three records for an employee, the first name, last name, and employee ID.
I need the drop down to give me both "fname", "lname", and the actual value needs to be "empl". first name, last name, and employee ID, respectively.
Is there some syntax that can be entered into the binding dialog that will call both "fname" and "lname" to show a full name. These employees are not going to be keen on selecting a first name, then a last name. Plus, if two people have the same last name, we could have conflicting employee ID's from first to last names.