Forum home » Delegate support and help forum » Microsoft Access Training and help » Drop down list for multiple customer addresses
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Drop down list for multiple customer addresses
Resolved · Low Priority · Version 2003
Reply Wed 18 Feb 2009, 16:32Delegate Rob said...
Rob has attended:
Access Introduction course
Drop down list for multiple customer addresses
how do you create a drop down list that allows the user to pick from a number of addresses for the same customer
For upcoming training course dates see: Pricing & availability
RE: Drop down list for multiple customer addresses
Dear Rob
Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.
In Intermediate Access course we cover a topic called Lookup wizard that allows a user to assign a drop down field where the user can choose from selected options.
Look up wizard is a data type that you assign to a field that allows you to look into another field in a table.
Typical example is that if you have a Product table that has Prod ID and there is a Order table where you can only see the Prod ID. You can use the Lookup Wizard to convert the Prod ID's to product names which is easier to understand.
It is quite easy to set up.
It is important that there is no relationship between the tables that you are planning to look up at the field.
I'll stick to my Product and order example.
1. If there is any relationship between the product and orders table delete the relationship in the relationship window.
2. Open the Orders table in design view.
3. Click on the Prod ID data Type drop down and choose Lookup Wizard
4. the first step of the wizard asks you if you want to lookup a column from an exiting Table or a query. Choose that option and then press Next
5. Choose the table or the query from the list and then press Next
6. Choose the filed that you wish to lookup from the table and then press Next
7. If t you want the filed to besorted ascending or Descending then choosee te field . Press Netx.
8. Adjust teh width of teh column. Press Next
Type the Label name for teh lookupcolumn. You can leave it teh same if you like. Press Finish
When you go to the data sheet view of the table you should be able to see the products names rather than the Prod ID.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Mon 2 Mar 2009: Automatically marked as resolved.
|