H
hcj
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.
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.
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.