Skip to main content
Participant
June 11, 2008
Question

for for updating database with referential integrity

  • June 11, 2008
  • 2 replies
  • 383 views
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

    This topic has been closed for replies.

    2 replies

    Inspiring
    June 11, 2008
    I'd use check boxes instead of a multi-select. Multi-selects are not intuitive and are too easy to make mistakes with.
    Participating Frequently
    June 11, 2008
    You put the capabilities in a multi-select box.
    <select name="capabilities" multiple="true">
    <option value="capability1">Capability 1</option>
    ...
    </select>