combo box values

[DW via AccessMonster.com]

I have created a combo box that is linked to an autolookup query so several
fields can be autofilled. To do this I linked two tables, one with contact
information (e.g. first and last names) of all needed contacts, and the
other with order information (e.g. purchase amount, items). I cannot get
all customerID values to show in the combo box to select from on my form.
The only customerID values that are displayed are values from data already
in the orders table and included in my query. I tried the join properties
and selected "include all records from "contact information" and only those
from "order information" where they are equal but this leaves blank values
for customerID in the combo box on the form. How can I get all available
CustomerID values to show in my combo box for use in further data entry
from my entire contact table?

 

[Nikos Yannacopoulos]

I tried the join properties and selected "include all records from

"contact information" and only those from "order information" where
they are equal

That's the right thing to do.

but this leaves blank values for customerID in the combo box on the form.

That's most likely because the CustomerID field in your query comes from
the "order information" table, whereas it should come from the "contact
information" table. Change this, and it should work fine.

HTH,
Nikos