LOOKUP FIELDS IN FORMS
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...
Forum Discussion
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:
------------------------------
Adam Keever
------------------------------
Here is what it would look like on a form:
------------------------------
Adam Keever
------------------------------
Becky,
Do what Adam said. He has laid out the whole architecture for you.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Do what Adam said. He has laid out the whole architecture for you.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
