Forum home » Delegate support and help forum » Microsoft Access Training and help » Creating look up tables
|
|
|
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. |
Creating look up tables
Resolved · Low Priority · Version 2007
Reply Tue 10 May 2011, 13:28Delegate Sarah said...
Sarah has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Creating look up tables
If I create my own values in a look up table when I'm building a database, can I add in extra values at a later date or do I have to capture them all at initial set up?
For upcoming training course dates see: Pricing & availability
RE: Creating look up tables
Hi Sarah,
Thank you for your question and welcome to the forum.
I assume the lookup values have been attached to a field in a table?
If so, open the table in Design view and select the field from the field list. At the bottom you should see a Field Properties Window.
Select the Lookup tab and click at the end of the Row Source field after the last lookup value entered. Enter a semi colon(;) followed by the new item for the list.
Alternatively do the Lookup Wizard again from scratch to include the full list.
I hope this answers your question. Let me know.
Regards
Simon
|