Auto look up fields

  • Thread starter Thread starter John Pennington
  • Start date Start date
J

John Pennington

I would like to find a product in an order sub form by
name and not by ID number as I do now.As I am new to
access I would be gratful for some help.

John
 
The best way to do this is with a combo box bound to your
ProductID field. Use the wizard, tell it to look up the
values in a table or query, choose the first two fields,
hide the key field, and store the user's selection to your
OrderDetail table's Product field. This field must match
in type to the ProductID key field, presumably Number.

The combo box will now display the second column, but
store the foreign key.

If you wish to display the descriptions in alphabetical
order, create a query sorted by Description, and base the
combo box on that.

HTH
Kevin Sprinkel
Becker & Frondorf
 
Back
Top