Lookup for two columns?

D

dindigul

I have a table with Nos & Names. In another table, I lookup for Nos in the
previous table, and want that the Names to be there also alongwith. Is it
possible? Thanks
 
R

Rick Brandt

dindigul said:
I have a table with Nos & Names. In another table, I lookup for Nos
in the previous table, and want that the Names to be there also
alongwith. Is it possible? Thanks
Click to expand...

You should not store the name in the second table. Linking by the ID is
enough. To *display* the name you can either use a ComboBox that stores the
ID, but displays the name or (if you want to see both) you can have both
columns in your ComboBox and then add a TextBox with a ControlSource of...

=ComboBoxName.Column(1)
 
Top