Value from a Lookup

[mana2]

I can't seem to save the correct value from a lookup table into a field. I have 4 fields:
SS#, Last Name, First Name, Middle Initial

I would like to save the Last Name, First Name into the field. Now I can just save the Last Name. Is there a way to combine the values?

So in my Lookup Tab, I have:
Combo Box
Table/query
Select ....
Bound Column 1
Column Count 4
Column Widths 0";1",1",1"

The other question is that the first column in the lookup (Last Name) always seems to be the value saved even if I change the Bound Column to 2 or 3.

Thanks so much.

 

[dhookom]

You shouldn't use lookup fields in table designs. Check

http://www.mvps.org/access/lookupfields.htm.

Also, are you attempting to store multiple values from one combo box into multiple fields? Access is a relational database so you should only store the person's name in one table and store a unique ID for the person in all related tables.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.