Discussions

Expand all | Collapse all

LOOKUP FIELDS IN FORMS

  • 1.  LOOKUP FIELDS IN FORMS

    Posted 22 days ago
    I HAVE A INSPECTIONS TABLE AND A  VIOLATIONS TABLE.  I WANT TO BE ABLE TO CHOOSE THE VIOLATION WHEN CREATING A NEW INSPECTION.   HOWEVER, INSPECTIONS CAN HAVE SEVERAL VIOLATIONS.  WHAT IS THE BEST WAY TO SET THIS UP?  I MADE A LOOKUP FIELD FOR VIOLATIONS BUT I DON'T KNOW HOW TO ADD MORE THAN ONE.  OR MAYBE THERE IS A BETTER WAY.

    ------------------------------
    Becky Moore
    ------------------------------


  • 2.  RE: LOOKUP FIELDS IN FORMS

    Posted 22 days ago
    Edited by Adam Keever 22 days ago
    You want to create a relationship where one inspection can have many violations. Then you can add multiple child violation records to an individual parent inspection record.
    Here is what it would look like on a form:

    You can change the settings so that you can add multiple child records from the parent record form:


    Then it will look like this:

    ------------------------------
    Adam Keever
    ------------------------------



  • 3.  RE: LOOKUP FIELDS IN FORMS

    Posted 21 days ago
    Becky,

    Do what Adam said.  He has laid out the whole architecture for you.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------