for for updating database with referential integrity

[Kulp-dvAEHx]

Hi:

Here is the essence of the problem:
I have created an Access database that I want the fire chiefs to update. The database is a one to many structure with referential integrity set. One fire truck has many capabilities. So if Fort Myers has a truck named 'FM101' and it has several capabilities such as 1.) pumper, 2.) extrication 3.) Advanced Life Support.

My problem is how to set up a form to do that. In particular, how do I set up the form so that it will allow the fire chiefs to input several capabilities at a time for a truck.

I can build a form showing the truck which was obtained from a pick-list. And I can show another field showing a pick-list for the capability of that truck (pumper, extrication, ALS, etc). My question is how do I set up the form to allow the chiefs to input multiple lines for the many capabilities of that one truck? Right now I have one input for the truck and one input for the capability - but I want to enable the user to input as many capabilities as they feel necessary.

How do I do that?

thanks

[Kronin555]

You put the capabilities in a multi-select box.
<select name="capabilities" multiple="true">
<option value="capability1">Capability 1</option>
...
</select>

[Dan_Bracuk]

I'd use check boxes instead of a multi-select. Multi-selects are not intuitive and are too easy to make mistakes with.