How to link a combo box and a text box

K

kcc

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
 
S

Sprinks

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
 
Top