> I am working on a table that was created by somebody who is not with
> the company.  I am trying to redesign the tables by including Employee
> ID, Last Name, First Name and Training ID.  On the design part of the
> table, he put Employee Name but when you go to the table, this shows a
> drop down with Last Name and First Name.  I would like to separate
> these two and have the names correspond to the Employee ID.  I have
> tried doing it on the Lookup/Display control but it is not working.
> Can somebody please help!
> Billy

> Hi Billy, take a closer look at the 'dropdown' in design view.  It very well
> could already be storing Employee ID, but *displaying* last name, first
> name.
>
> While in design view, click on that field in the upper pane and in the lower
> pane click on Lookup tab.
>
> If you can't figure it out, post back with the field name, the control type,
> and rowsource information.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Billy wrote:
> > I am working on a table that was created by somebody who is not with
> > the company.  I am trying to redesign the tables by including Employee
> > ID, Last Name, First Name and Training ID.  On the design part of the
> > table, he put Employee Name but when you go to the table, this shows a
> > drop down with Last Name and First Name.  I would like to separate
> > these two and have the names correspond to the Employee ID.  I have
> > tried doing it on the Lookup/Display control but it is not working.
> > Can somebody please help!
> > Billy

> Thanks Joan
> I am getting some strang things going on in this database.
>
> Here is what happens:
>
> The fields are--- Employee ID, Last Name, First Name
> When I highlight the Last Name then to Lookup, I put Display Control
> as Combo Box, Row Type-Query/Table, Row Source-Employee Table.
> When I go to the Table, the drop box shows the last names but it is
> not populating the column.
> I do the same with First Name but in this case, I am getting last name
> on the drop down box.
>
> HTH
>
> Billy
> Joan Wild wrote:
>> Hi Billy, take a closer look at the 'dropdown' in design view.  It
>> very well could already be storing Employee ID, but *displaying*
>> last name, first name.
>>
>> While in design view, click on that field in the upper pane and in
>> the lower pane click on Lookup tab.
>>
>> If you can't figure it out, post back with the field name, the
>> control type, and rowsource information.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Billy wrote:
>>> I am working on a table that was created by somebody who is not with
>>> the company.  I am trying to redesign the tables by including
>>> Employee ID, Last Name, First Name and Training ID.  On the design
>>> part of the table, he put Employee Name but when you go to the
>>> table, this shows a drop down with Last Name and First Name.  I
>>> would like to separate these two and have the names correspond to
>>> the Employee ID.  I have tried doing it on the Lookup/Display
>>> control but it is not working. Can somebody please help!
>>> Billy

> I didn't want you to create a lookup in the table; just check to see *if*
> there was one already.
>
> From what you say, this table has a field named Employee ID, Last Name, and
> First Name.
>
> What you really need is just Employee ID, and not the other two.
>
> But first, create a separate table for the EmployeeID, LastName and
> FirstName.  You can create a query to append the existing values to this
> table.
>
> Once that is done, you can remove Last Name/First Name from your original
> table.
>
> Although you can create a 'lookup' on the EmployeeID field to look up the
> LastName/FirstName, you don't want to do that.  Tables are just for storing
> data - they shouldn't show you data that isn't stored there.
>
> Instead create a combobox on your forms to lookup the LastName/FirstName and
> store the EmployeeID in the EmployeeID field.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Billy wrote:
> > Thanks Joan
> > I am getting some strang things going on in this database.
> >
> > Here is what happens:
> >
> > The fields are--- Employee ID, Last Name, First Name
> > When I highlight the Last Name then to Lookup, I put Display Control
> > as Combo Box, Row Type-Query/Table, Row Source-Employee Table.
> > When I go to the Table, the drop box shows the last names but it is
> > not populating the column.
> > I do the same with First Name but in this case, I am getting last name
> > on the drop down box.
> >
> > HTH
> >
> > Billy
> > Joan Wild wrote:
> >> Hi Billy, take a closer look at the 'dropdown' in design view.  It
> >> very well could already be storing Employee ID, but *displaying*
> >> last name, first name.
> >>
> >> While in design view, click on that field in the upper pane and in
> >> the lower pane click on Lookup tab.
> >>
> >> If you can't figure it out, post back with the field name, the
> >> control type, and rowsource information.
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Billy wrote:
> >>> I am working on a table that was created by somebody who is not with
> >>> the company.  I am trying to redesign the tables by including
> >>> Employee ID, Last Name, First Name and Training ID.  On the design
> >>> part of the table, he put Employee Name but when you go to the
> >>> table, this shows a drop down with Last Name and First Name.  I
> >>> would like to separate these two and have the names correspond to
> >>> the Employee ID.  I have tried doing it on the Lookup/Display
> >>> control but it is not working. Can somebody please help!
> >>> Billy