|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 1st, 2005, 05:15 AM
|
|||
|
|||
How do I have multiple selections in a look up field in access?
I am trying to build a table and one of the fields requires the user to make
more than one selection from a drop down menu or in a list. I know it is easy to make it so only 1 is able to be selected but how do you make it for multiple selections ?? Any help would be greatly appreciated. 
|
|
#2
March 1st, 2005, 05:29 AM
|
|||
|
|||
|
Lookup fields are generally considered poor design
http://www.mvps.org/access/lookupfields.htm. Also attempting to store multiple values in a single field is not a good idea. Read up on normalization. I think you might need a related table that would contain one record for each "desired" selection from your multiple selections. -- Duane Hookom MS Access MVP "kernalz" wrote in message ... I am trying to build a table and one of the fields requires the user to make more than one selection from a drop down menu or in a list. I know it is easy to make it so only 1 is able to be selected but how do you make it for multiple selections ?? Any help would be greatly appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| enable multiple selections in drawing explorer | fishyfish | Visio | 0 | December 23rd, 2004 02:17 PM |
| STORE multiple values from a lookup table to another table. | beller | Database Design | 0 | June 15th, 2004 04:42 AM |
| Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
| Multiple values in a single cell, and validation | Harlan Grove | Worksheet Functions | 1 | December 5th, 2003 07:58 PM |
Linear Mode
