Linking text to serperate tables

  • Thread starter Thread starter Jason
  • Start date Start date
J

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.
 
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
 
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




.
Click to expand...
 
Back
Top