Multiple combo or list box for the one item.

[Len]

I have limited experience with Access but decided to set one up to record our
product enquiries. Most times people will enquire about one product only but
sometimes it maybe two or three. I have an enquiry/contact table but need to
set up a series of combo or list boxes to select the products (multiple) they
are enquiring about. I have access 2007 and tried the list that stores
multiple values which sort of worked... ie. i could select a couple of
different products per enquiry but it updated all enquiries with the same
information so obviously i dont have something right. Perhaps it is not the
right option?? I set up a product table as well.
Could someone please advise the correct options i should be using to do this
type of thing.

Many thanks

Len

 

[Len]

Just an addition to my first request. I am assuming I would need three or
four fields on the form to enable each item selected to be displayed.
Thanks

Len

 

[Damon Heron]

Some questions:
Is this db going to be used by the customer or just you to record the
customer inquiries?
A good house requires a good foundation, so how is your products table set
up?
Do you have product categories? If so, then it makes a large product list
easier to setup and manage.

EX:
tblProducts
ProdID
ProdType
ProdName
Description
etc.,

tblProdType
PTID
ProdType


You mentioned a inquiry/contact table -- Split these tables.

tblContact
ContactID
ContactName
ContactAddress
etc.

tblInquiries
InqID
ContactID
ProductID

If you don't know about table relations and foreign keys, then do some
reading.
Before you design your forms, create some queries with test data and get an
understanding
of how you can access the data.

hth
Damon

 

[Len]

Dear Damon

Thank you so much for replying. This is for internal use only...
I have to tell you I did cheat a little in that I downloaded one of the
Microsoft Templates so know it is set up properly as far as the tables go. I
did ad an extra table for the products and have only listed the major groups.
I set up one combo box and it worked fine but because I wanted to show each
product enquired about on the form this didnt work. When I added a second
combo box and selected the item it automatically changed the first item. I
then tried the multiple option listed below and while i was able to select
different products on the one contact... it changed the products on the rest
of the contacts...if this makes sens... I am sure it is something simple but
not sure what ...

Thanks

Len