Linking Text to Seperate Tables

[Jason]

Okay here is the situation.

Table A Table B
(pk)Name
Code Number---------(pk)Code Number
Code Description

Form1
On this form I have a combo box from witch they can choose
one of the the code numbers from table A. Below the combo
box I have a text box that I would like to display the
description from table B that is linked to the option they
choose in the combo box. If anyone can help me do this,
it would be very much appreciated. As it stands I know
how to source it to table B but not to display the related
information that was chosen in the combo box. Thanks.

 

[Marshall Barton]

Okay here is the situation.

Table A Table B
(pk)Name
Code Number---------(pk)Code Number
Code Description

Form1
On this form I have a combo box from witch they can choose
one of the the code numbers from table A. Below the combo
box I have a text box that I would like to display the
description from table B that is linked to the option they
choose in the combo box. If anyone can help me do this,
it would be very much appreciated. As it stands I know
how to source it to table B but not to display the related
information that was chosen in the combo box. Thanks.

Make sure the combo box's RwoSource query includes both the
code and the description. Then the text box can refer to
the description by using the combo box's Column property
(see Help for details).

 

[Guest]

Thank you very much

-----Original Message-----



Make sure the combo box's RwoSource query includes both the
code and the description. Then the text box can refer to
the description by using the combo box's Column property
(see Help for details).