Allow multiple selections from a lookup field

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
Tucker22Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Tucker22Connect With a Mentor Author Commented:
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
All Courses

From novice to tech pro — start learning today.