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
------------------------------
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
------------------------------
------------------------------
Raj Helaiya
------------------------------
- You would need to use dynamic form rules in the form settings:
You may need to use a formula field to compute a result for multiple conditions and then apply a dynamic form rule to that formula field depending on exactly what it is you need to do.
------------------------------
Adam Keever
------------------------------