capturing multiple values

[itsozzy2003]

Hi Guys,

I have hit a brick wall and hoping someone can help me. I am fairly new to access. I am working on designing a form, a section in the form needs to capture information if the customer has other suppliers.

So I have a question in my form "does the customer have other suppliers?", If the user selects yes by ticking the tick box, i want a list box to populate with a list of 7-8 suppliers e.g ABC,BBC,CBC,DBC,EBC,FBC,GBC. now i want to users to be able to select multiple supliers but i am not sure how to capture the details of these multiple supplier.

So when we run a query like show me who are the supliers for customer John Smith, it should display all the suppliers.

Any assistance is greatly appreciated.
Cheers,
Oz

 

[pbaldy]

Normal design would have the suppliers in a related one-to-many table. You could add them using a technique like this:

http://www.baldyweb.com/MultiselectAppend.htm

 

[itsozzy2003]

Thanks for the quick reply pbaldy, but i am quite confused with the example you gave me, and my coding knowledge is zero. could you or somebody mock an example based on my scenario i.e with the supplier list.

so when some tick the box for does the client have other supplier they can select multiple supplier from a list box and store those value is a table.

your assistance is highly appreciated.