combo box questions.....

[bigeyespanda]

Hi... I am doing a database to store inventory details. I had a Combo Box for users to select the type of the product. The values of the combo box is retreving from the TypeTable (which has TypeID, TypeName, SubType). The combo box will store the value of TypeID into the ProductTable. Then, once you click the arrow, it will show all the TypeID, TypeName and SubType info. Of course, if I choose say '1', then the combo box will show the number 1 in there. Because '1' means nothing for a user when they use this database, they only know the TypeName (e.g. Toy), so.... is there any solutions that can display the TypeName after the user select from the combo box?

Thank you!!!!

bigeyespanda

 

[ColinEssex]

Have the column with set to 0 for TypeID

Col