Drop Down on Table

  • Thread starter Thread starter Billy
  • Start date Start date
B

Billy

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.
 
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
 
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,
As always, thanks for your help. I figured out what the problem was.
It is fixed.
Billy
 
Back
Top