L
Len
I have limited experience with Access but need to know how I set up multiple
fields on a form using the one list or combo box. I am setting up a database
to enter in product enquiries. I set up a table to list the various products
but need to be able to select more than one product for the one enquiry. I
have Access 2007 which is very new to me and tried the "list which stores
multiple values" but when i updated one of the enquires it updated for every
enquiry so obviously I am not doing it correctly.
Could someone please advise the correct way of listing the various different
products in the one enquiry (may only be 2 or 3 different products per
enquiry).
Many Thanks
Len
fields on a form using the one list or combo box. I am setting up a database
to enter in product enquiries. I set up a table to list the various products
but need to be able to select more than one product for the one enquiry. I
have Access 2007 which is very new to me and tried the "list which stores
multiple values" but when i updated one of the enquires it updated for every
enquiry so obviously I am not doing it correctly.
Could someone please advise the correct way of listing the various different
products in the one enquiry (may only be 2 or 3 different products per
enquiry).
Many Thanks
Len