Value from ComboBox

[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. I can just save the Last Name. Is there a way to combine the values or to save more then one bound column?

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

Thanks so much.

 

[Rich]

The only value you should be saving is the P.K. of the lookup table as the F.K. in your other tables. The names can be retrieved via a query or calculated fields

 

[mana2]

Not sure

I'm using the same field on one form to enter and save the data. So the user would use the lookup to enter or change a name in a field. Should I be using 2 fields? 1 to store the primary key and 1 to display the data? I'm not quite sure since I'm new at this.

Thanks

 

[mana2]

One more question

I've created 2 fields and just want to make sure I'm on the right track. The first field has the primary key, employee number saved. The second field has the query but I'm having a problem with it.

So in my 2nd field which is Name, in the Control Source of the field Properties, I have the following select statement:

SELECT Personnel.[First Name], Personnel.[Last Name], Personnel.SSN, SalaryInfo.[Supervisor Number] AS Expr1
FROM Personnel
WHERE ((([Personnel]![Employee Number])=[SalaryInfo]![Supervisor Number]));

I get the #NAME? Error when trying to view it in the form.

Thanks

 

[ray705]

Take a look at the attached and see if it is what you need.

 

[mana2]

Thank You

Thanks so much. Your example helped and I was able to make it work.