Combo Box looking up records

  • Thread starter Thread starter Deena
  • Start date Start date
D

Deena

I have a table that has Customer and Facility. These two
fields together provide a unique key, but either one
alone is not unique. I am tryng to use a Combo Box on a
form that has Facility and Customer as the drop down list
to get the right Facility for the right Customer. The
Combo Box is unbound. Facility is the bound column. I
expected this to fully qualify the record to look up.
However, It brings up the first matching Facility and
ignores Customer. Even if I filter the list to only one
Customer it stills only uses Facility.
Any suggestions on how to do what I need to do? I do not
code in Visual Basic, but can write SQL queries. Any
help will be greatly appreciated. I was just ready to
put this application to bed, when I discovered this
problem.
 
I have a table that has Customer and Facility. These two
fields together provide a unique key, but either one
alone is not unique. I am tryng to use a Combo Box on a
form that has Facility and Customer as the drop down list
to get the right Facility for the right Customer. The
Combo Box is unbound. Facility is the bound column. I
expected this to fully qualify the record to look up.
However, It brings up the first matching Facility and
ignores Customer. Even if I filter the list to only one
Customer it stills only uses Facility.
Any suggestions on how to do what I need to do? I do not
code in Visual Basic, but can write SQL queries. Any
help will be greatly appreciated. I was just ready to
put this application to bed, when I discovered this
problem.
Click to expand...

A combo box has only one value, so it may be difficult to do this with
only one combo. Could you perhaps use two combos, the second dependent
on the selection from the first? See http://www.mvps.org/access and
search for "Dependent combo" for some suggestions on how to set this
up.
 
Back
Top