Forum home » Delegate support and help forum » Microsoft Access Training and help » Multiple value choice
|
|
|
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. |
Multiple value choice
Resolved · Medium Priority · Version 2007
Reply Mon 23 May 2011, 10:59Delegate Dorota said...
Dorota has attended:
Access Introduction course
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Excel VBA Intro Intermediate course
Multiple value choice
Hi
I have been trying to change the settings of one of the fields in our contact database to allow us to select multiple values. I have tried to do it by going through the lookup wizard and at the end of the process select "Allow multiple values for this lookup" option, but this option does not appear at all. Would you be able to help me with this problem.
Thank you
dorota
For upcoming training course dates see: Pricing & availability
RE: Multiple value choice
Hi Dorota, thanks for your query. This is a difficult one to advise you on because it sounds like it depends on the underlying structure of the database. First of all, double check you have created the lookup field correctly, secondly, in design view on the table, switch to the lookup tab of the field properties and try changing Allow Multiple Values in there. Thirdly, if none of these work, look at the relationships between the tables, particularly if the Lookup is being generated by a one-to-one table relationship anywhere.
Anthony
Reply Tue 24 May 2011, 14:49Delegate Dorota said...
RE: Multiple value choice
Hi Anthony, thank you for your message. Unfortunately, I have not been able to resolve the problem. I decided to create a new field and re-enter the valus for it, but the wizard does not allow me to select the "Allow Multiple Values" choice. Would you be able to help me with this, please?
Many thanks
Dorota
|