How to link a combo box and a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1 text box and 1 combo box with data of id and description.
when input id in the text box, the combo box show the corresponding
description and store in a table; when select the description from the combo
box, the text box shows the id and both id and description store at the same
table.
How to do that? thanks
 
Hi, KCC.

I don't understand why you'd want to store both the ID AND the Description.
The foreign key ID is all you need as far as I can see.

If you're trying to permit the user to either select by Description or ID,
make two combo boxes, one with 2 columns, with the ID column set to 0", and a
second combo box that has just the ID. Then whichever the user enters, the
other will display the corresponding data.

Hope that helps.
Sprinks
 
Back
Top