Lookup for two columns?

  • Thread starter Thread starter dindigul
  • Start date Start date
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
 
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)
 
Back
Top