itsozzy2003
New member
- Local time
- Today, 11:03
- Joined
- Sep 23, 2010
- Messages
- 2
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
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