Thanks Adam, I think this is an easier way to go. But I have a condition, if there are multiple fields in the child table and on the parent table I want to display certain fields based on certain conditions, say if a check box is checked only show 2 out of 3 fields from the child table when add button is clicked on the parent form. How does that work?
------------------------------
Raj Helaiya
------------------------------
Original Message:
Sent: 11-21-2019 15:18
From: Adam Keever
Subject: LOOKUP FIELDS IN FORMS
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
Original Message:
Sent: 11-21-2019 14:39
From: Becky Moore
Subject: 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 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
------------------------------