Combox store the ID not the corresponding value to the table

[jaffermca]

Hai guys,



I am newbie to access database, I have 2 tables namely business_unit(id,b_unit) and division(id(pk), bid(fk),division) . I have created 2 combo box in my form one for b_unit and another division, based on the selection of b_unit the related division will be loaded in division.

If i try to store the b_unit and division value from the form to the table called "training" it stores only both of the field ID's not its value.

Please any of you help me out.

I execute this query ,


Private Sub Command12_Click()
CurrentDb.Execute "INSERT INTO training(business_unit,division)" & _
"values(" & Me.business_unit & ",'" & Me.division & " ')"
End Sub

[pbaldy]

That is what is normally done; you store the primary key of a "lookup" table in related tables. You get the corresponding values for forms and reports by joining the tables together in a query.