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
|
|||
|
|||
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
|
|||
|
|||
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 |