Form: Cascading Combo Box: Select ALL? or Multiple Values? (1 Viewer)

[Synses]

I have a form with a cascading combo box that was created for me here by S. Neuberg (I am so very grateful).
First Field is for user to select the Client.
Second Field is for user to select the Facility.
(some clients have only one facility, some have many)

The user will enter a "Lesson Learned" report that will be saved to the facility table.
Problem:
Some lessons learned will apply to all faciltiies.
Some lessons learned will apply to several.
Some will apply to only one.
All Lessons Learned need to also be linked to the Client Table somehow.

1. How can I give the user an "ALL" selection for ALL the facilities for that client?
2. How can I give the user a "select several" selection for SOME of the facilities for that client?
3. How can I link all the Lessons Learned to the table for the Client, so there is an option to report all lesons learned for the all facilities for that client, or is that an option I will find and use when I create the Reports?

Any suggestion on how to do those things would be greatly appreciated!!!
Synthia
DB attached.

 

[Ranman256]

make a 'picked' table, tPicked.
show the user a list box with all available items to choose from,
another list box to show what was picked, tPicked table.
User then dbl-clicks the available list and an append query adds it to the picked list.
a delete query can remove item from the pick list.
a button can run a query to add ALL items in the available list to the picked list.

then make a query that joins the picked list to the data table. Only those items in the picked list will get pulled.