Lookup Column Display

[DDEB]

I've created a lookup column that brings a name from Table 1 to Table 2. In Table 1 the name is divided into 3 columns: Extension (Primary Key), First Name, and Last Name. In Table 2 I'm combing these three columns into one using a Lookup Column. When I go to datasheet view in Table 2 this column is only displaying the First Name, I can only see the Last Name if I click on the drop down button. The Lookup Column is working fine in terms of functionality, the issue is with how it's displayed. I need to be able to see both First Name and Last Name without clicking on the drop down. As I've built queries and reports it continues to only display the first name, which won't work if I need to print anything. My lookup column properties are as follows:




Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT [CSR].Extension, [CSR].[First Name], [CSR].[Last Name] FROM CSR ORDER BY [First Name];
Bound Column: 1
Column Count: 3
Column Heads: No
Column Widths: 0cm;2.54cm;2.54cm

I've tried making the ORDER BY [First Name], [Last Name]; but that didn't work.

Any help would be appreciated!

[PRMiller]

Try this:

Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT CSR.Extension, CSR.[First Name] & " " & CSR.[Last Name] AS FullName FROM CSR;
Bound Column: 1
Column Count: 2
Column Heads: No
Column Widths: 0cm;2.54cm