Solved

Allow multiple selections from a lookup field

Posted on 2011-03-12
1
421 Views
Last Modified: 2012-05-11
I have a tribal database with many existing tables, queries and forms, and with relationships already established.  Is there a way to convert four lookup fields in the Applicable Facility Requirements table (design shown below in attached file) to allow users to select more than one option in each lookup table--hopefully without having to delete relationships already established?   FacilityID has a primary key on the Facility table. The attached file shows only the 6 tables referred to above. Thank you.   Question-for-Experts-Exchange.docx
0
Comment
Question by:Tucker22
1 Comment
 

Accepted Solution

by:
Tucker22 earned 0 total points
ID: 35118524
It looks like I have found the easy solution: In table design, select the current lookup field (e.g., EmissGL-Subpart); Click Lookup tab on Field Properties for this field, which is a combo box; and set Allow Multiple Values to "Yes."
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now