Combo Box Problems...

[Fulcrum]

I thought even I could manage combo boxes but it seems not......
I want to make a combo box that will show Employee First and Last Names form my Employees Table on my Assets Form under Engineer. I tried using the wizard which showed the first and last names in the drop down box but when you select a name it only inputs the First name and in the Assets table under Engineer it shows the Employees ID Number.
I also tried different SQL statements in the properties window but all I seem to get are Parameter boxes comming up instead of the drop down box.
If anyone Knows the soloution to this please let me know..
Thanks

 

[Rich]

The second part of your question is actually the correct method for storing the Foreign key in your assets table.
If you want to display first and last name in your combo then join them in the underlying query for the combo
ie [FirstName]&" "&[LastName]