I have a table called "stock" that contains a field "Model". I have
another table called "Models" that contains a list of valid models.
How do I setup a lookupcombobox to display a dropdown list from
the "Models" table and update the "model" field in the "stock" table.
The field to display in the dropdown box is "Modelname" and this is
also the value to update the stock table with.

Any ideas ?

Johan Kotze