Combo boxes and Lookup Tables

[crystal0streaks]

I have a table that has combo boxes of [MODEL#] and [PRICE] how do I make it so when I select a Model# the appropriate price is automatically inserted in the [PRICE] column? I've been told I should do this with a Lookup Table, but when I use the wizard it creates a combo box like the one I already had. Is there any way to rid of the combo box in the [PRICE] column?

-crys

 

[Remou]

I hope you have not added look-ups to your table. it is not a good idea. You should put lookups as comboboxes on a form.
In the case above, you could have a form bound to a 'main' table with a Model combobox. You could then add code to the After Update event of the combobox to write the selected ModelID and Price to the appropriate controls.