Linking text to serperate 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.

 

[Larry Linson]

Use a multiple-field query for the Combo which includes the text from Table
B, and use the Column property of the Combo to retrieve the text.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thank you very much

-----Original Message-----
Use a multiple-field query for the Combo which includes the text from Table
B, and use the Column property of the Combo to retrieve the text.

Larry Linson
Microsoft Access MVP




.