Dropdown list info not correct in table

[hendrikbez]

Using Access 2010
I have build a new form with textboxes and 5 dropdown list boxes.

I have make a main table where all the info must go into that it is getting from the vorm input.
I have also make 5 different tables were the info of the dropdown list is in.
I have make each dropdown list to get info form its table and then add it to main table.
But when I add info in my vorm and save it, on the vorm it shows the correct info, but on my main table
It shows the ID # for each dropdown list and not the info that I need.

Eg. Here is one of my tables

ID Client
1 Prasa
2 Data


3 Info
4 Piet
5 Jan

But it show in main table ID # 5 instead of Jan in the column Client

I have add the file to look at

[NTC]

The combobox is bound to the ID field and so that is what is stored in the table. It is a matter of understanding. Any time you wish to view the text, rather than the ID, you join that Client table to the main table so you have the Client text field available.

Or you can remake your Client table to not have any ID, then remake your combobox so it will only have a text field....