| | |
|
|
|
Combo box with two fields |
|---|
| message from =?Utf-8?B?U2Ft?= on 21 May 2004 |
Hi everyone,
I am trying to create a combo box to find records on a form; i am using in the combo box the customer name field and the item purchased field. When i choose a name from the combo box i get the customer in question with all his purchased items and not only the one i want.
Can someone help me?
|
| hcj replied to =?Utf-8?B?U2Ft?= on 21 May 2004 |
Appears that combo box is filled from a query with one
customer to many purchases. If purchase record has a
unique ID, include that in the query output and make your
combo box connect to that field for uniqueness. You can
choose whether to display the ID field in the combo box or
not, but better to display it if not too messy.
Key here is to connect the combo box to some field unique
to the single record you want.
Hope this helps.
form; i am using in the combo box the customer name field
and the item purchased field. When i choose a name from
the combo box i get the customer in question with all his
purchased items and not only the one i want.
|
|
Archived message: Combo box with two fields (Microsoft Access)
