I can't seem to get the following done.
I have a database with 3 tables: 1 for Employees(table a) 1 for products(table b) and one for use of products by employees (table c).
Now I want to create a form in which a combo gives the opportunity to select one employee from table a, another combo gives the opportunity to select one product from table, and writes the selected choise down in table c.

But my combo only shows the first employee or product it can find.
How do I fix this?

And to make it more complicated, in the combo I want to see the description of the field, but in table c I want to write down the indentifier.
How can I do this? Anyone know?