LOOKUP FIELDS IN FORMS

Question

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
------------------------------

AdamKeever1 · Answer

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
------------------------------

Sign up

Login to the community