Help with combo box and query...

[THenry]

Hi people...

I have 2 tables, "Language"and "LangChart". The 2 tables and joined by a field called "LangCode" in relationship.

"Language" will contain the language abilities of the user, with the fields (LangID, LangCode, Level, SubLevel and ID)

"LangChart" is just a chart to verify which language type belongs to which code, e.g. English is ENG, Japanese is JAP. The fields are (LangCode and Language).

I have created a form called Language which updates all the data fields in the language table.

I have set the langcode field (common across the 2 tables) be a combo box which displays the language types like English and Japanese in the drop down menu. But upon selecting the language type, the langcode (ENG, JAP) will be capture instead of language name, and updated into the language table.

Is there anyway to accomplish the above?

Thanks in advance.

 

[mark curtis]

first you do not need the relationship as it is just a table to populate a combo box.

if you dont want to store the code then change the properties of the combo to bound field 2 assuming that the code is 1 and detail is 2.

 

[THenry]

Oops, think I did not phrase myself properly, was too sleepy when post my question

I want to create a combo box to display the language type from table "LangChart", but upon choosing the language type from the combo box, the value should be entered as "LangCode" into the "Language" table instead.

Please advise, thanks again in advance.

 

[Rich]

No, you should store the code in the language table, use queries to return the actual value

 

[THenry]

The code is stored in the language table, but i need another table to verify which language belongs to which code right?

The "LangChart" table does that in my case.

 

[SforSoftware]

Hi,

Base your combobox on table LangChart, with the two columns.
First column is Code and second Language.
Set the bound column to 1 (code).
You can hide that column by setting the columnwidth to e.d.:
0;3

The controlsource of the combobox must be the Code-field from table Language

 

[THenry]

Thanks dude! That worked nicely