Lookup Wizard

[Jdougal via AccessMonster.com]

I've used the lookup wizard to pull information into my main table.

Tbl SignUp has a record for name
There is a Tbl EmployeeInfo which has records for First, Last, and ID number.


The record for name looks up all three of these records. In the form where
the information is selected I have a drop down menu. The last, first, and ID
number is displayed as an option. When you select the data it only inserts
the first name into the record in Tbl SignUp.

I either want all the info, (first, last, and ID), or have the last last name
inserted. We have several employees with the same first name so the current
method will not work.

Can anyone help?

Thanks

 

[Duane Hookom]

Consider not using lookup fields
http://www.mvps.org/access/lookupfields.htm. You should be using forms with
combo boxes. The primary key from the employee table should be stored in the
sign up table.

 

[Bob Miller]

I would recommend that you insert the ID number in your table and no
the names. The beauty of a relational db is that you can do that an
still be able to retrieve the name when needed.
When you are using a combo box to insert data into a table, the boun
column is what is stored. Look a the properties of the combo and se
which column is bound. If the order of the columns of you employe
table is First, Last, ID and First is inserted in your table then yo
must have 1. Change it to 3 after you have changed the SignUp table'
field name to ID and type to a number (same type as the ID field in th
employee table.)
Remember to not delete employees from the employee table. Find
method to retire/fire them (a checkbox field maybe.)
BTW, don't put a lookup in a table unless that is where data entr
takes place.