Combo Box linked to Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please Help

I created a form with a Combo Box that displays Employee names from a Table named Employees. I also have a table named Tech Skills that takes all the data entered in the form and loads into this table. The issue is that once the employee name is selected from the combo box it appears on my Tech Skills table as a number instead of the Employees name. How can I correct this?

Thank you in advance for your help!
 
Michael

It sounds very much like your database is doing ... exactly what it should!
Once you have a table with Employee info in it, there's no good reason (and
plenty of bad reasons) to "copy" information (like a name) into another
table. By storing the ID# (that's what I'm interpreting your description to
mean) of the Employee, you avoid problems downstream and follow good design
principles.

If you need to see the name of the Employee, use a query, populate a form.
You probably don't want to be messing around in the tables, except to
originally build the database.
 
Back
Top