I just feel like I'm missing something really stupid. I have a simple access database I'm using for tracking my projects. I have multiple individuals and I have multiple projects. For the project, I have a drop down and I can select the lead for the project from my list of employees. No problem. however, it only displays the first name of the person. How do I get it to display the first and last name?
- Table 1: ID, firstName, lastName
- Table 2: ID, lead, notes - "lead" is a long integer.
The Row Source is
SELECT [Table1].[ID], [Table1].[lastName], [Table1].[firstName], [Table1].[Position] FROM Applicants ORDER BY [lastName], [firstName];
On the Form, I get the drop down box. It shows the first, last name, and what position they have but once I select the person I want, it only shows the first name.
The database is far more complex then this but none of the other information is relevant.