LookUp/Combo Box help

  • Thread starter Thread starter Joy Rose
  • Start date Start date
J

Joy Rose

I havea table Products and a table Order Details. On the Order Details
table, I have ProductCode as a lookup box to the products table.

There is also a subform - Order Details within my orders form.

If information is entered directly into the table Order Details, the lookup
box only pulls information from that one field although I can see all the
fields with I click on the drop down arrow.

If information is entered into the subform Order Details, the drop down
arrow pulls all pertinent information into the fields on the form; i.e.
description, codes, unit price.

What do I need to do?
 
I'm not sure what you're asking, but examine the Northwind example database,
as it may offer some insight.
 
I have a form -- Order Details that uses fields from Product Table. The
main field is a combo box that will pull the price, product code and
description and insert information in each of these fields. However, when I
enter the main field info directly into the table, this information does not
insert into the other fields. Why?
 
Back
Top